Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I have below format in the excel file :
Year/Month | Category Type | January | February | ||
Gender | Male | Female | Male | Female | |
2018 | Category 1 | 2 | 5 | ||
Category 2 | 10 | 12 | |||
3 Category | 45 | 22 | |||
Category 4 | 20 | 10 | |||
2019 | Category 1 | 12 | 55 | ||
Category 2 | 77 | 3 | |||
3 Category | 66 | 2 | |||
Category 4 | 44 | 5 |
And this is our expectation in the qlik sense table :
Note: We have 4 years of the data ( 2018 to 2022) and we have 8 categories also we need to show for all the month.
In above example it is showing only for 2 months.
Kindly help.
Regards,
Mahamed.
Solution anyone ???
Hi
See this post
https://community.qlik.com/t5/New-to-Qlik-Sense/Excel-load-with-Cross-Table/td-p/1694647
both of solution are OK
regards
Thank you for your response, but given solution does not suits in our case.
Awaiting for solution