Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have requirement below. I need to create a table based on the excel data, I have given the requirement in the excel .
can anyone please help
Product | Month | Refered | Refreerd% | MY REqUIREMENT | ||||||
Cards | 18-Jan | 123 | 23% | By Product | Actuals | |||||
Loans | 18-Jan | 34 | 38% | 18-Jan | 18-Feb | 18-Mar | 18-Apr | |||
Cards | 18-Feb | 54 | 23% | Cards | ||||||
Loans | 18-Feb | 43 | 38% | Referred Volumes | 123 | 54 | 54 | 23 | ||
Cards | 18-Mar | 54 | 23% | Referred | 23% | 38% | 23% | 28% | ||
Loans | 18-Mar | 123 | 38% | Loans | ||||||
Cards | 18-Apr | 23 | 23% | Referred Volumes | 34 | 43 | 123 | 23 | ||
Loans | 18-Apr | 23 | 38% | Referred | 23% | 38% | 23% | 38% | ||
Cards | 18-May | 123 | 23% | |||||||
Loans | 18-May | 432 | 38% | |||||||
Cards | 18-Jun | 567 | 23% | |||||||
Loans | 18-Jun | 342 | 38% | |||||||
Cards | 18-Jul | 32 | 23% | |||||||
Loans | 18-Jul | 12 | 38% | |||||||
Cards | 18-Aug | 12 | 23% | |||||||
Loans | 18-Aug | 23 | 38% | |||||||
To get the output you need a pivot table to do the grouping.
Product and Month as Dimensions.
Sum(Refered) as Expression and sum(Refreerd%) as Expression.
Expand Product column. Sort Month by load order.
In addition to what Lisa gave you, the following Design Blog may prove helpful too:
https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083
Here is the base URL if you want to do some further searching on your own there, there are over 700 posts from our experts and most are how-to based.
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett