Qlik_024: Load_Type_01: Crosstable_02: Crosstable for multiple attribute and multiple data fields.

In this video, we will see how to use Crosstable to convert pivoted data having multiple attribute field names or multiple data field names.
Read more about
Crosstable:
help.qlik.com/...
Henric Cronstrom blog post on Crosstable:
community.qlik...
Check my previous video on Crosstable
• Qlik_021: Load_Type_01...
You can also find me on
KZbin: / @manishkumarkachhia1683
Facebook: www.facebook.c...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: www.udemy.com/...
#qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #weekstart #weekend #setanalysis #pointintimereporting #ytd #pytd #mtd #pmtd #wtd #pwtd #qtd #pqtd #setmodifier #setidentifier #setoperator #yeartodate #previousyeartodate #quartertodate #previousquartertodate #monthtodate #previousmonthtodate #weektodate #previousweektodate
#crosstable

[@wendywu5359]

Good quality video

[@Enaklam]

Very good, thanks

[@Rlb70001]

I think it's very comum people use crosstable MonthYear to add MonthYear goals. I'd like to know if you have any video that show us how to make an expression to check this MonthYear per Workday. Example: I have 260,000 as a goal for Jan/23 and I have 26 working days for this month. My sales from 01/JAN/23 TO 15/JAN/23 was 130,000 - (12 working days) So... I've already made 50% of my JAN/23 goal. And for the first 15 days (12 working days) I'm 108,3% Many thanks again.

[@Rlb70001]

Hi first of all, your videos are great. Many thanks for sharing. I have a question about goals. I've already have a two tables in the script. Sales and Calendar Sales. When I add Goals Table with MonthYear I've a problem with Circular Reference. "MonthYear". Do you have any sugestion to fix it?

[@wendywu5359]

Question is if the second table, Monty year are the same, how to differentiate target and sales, as this is often the case in reality? Thanks!

[@manishkumarkachhia1683]

You can add 'Sales' as Flag, 'Target' as Flag .... If you give me exact dummy data, I can help you further.