Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have the underlying data
Type | Date [2018] |
---|---|
Type 1 | Jan |
Type 1 | Type 2 | Type 4 | Feb |
Type 3 | Type 4 | Mar |
Type 1 | Type 3 | Type 4 | Jan |
Type 1 | Feb |
and I need Qlikview to show this:
Type | Jan | Feb | Mar |
---|---|---|---|
Type 1 | 2 | 2 | |
Type 2 | 1 | ||
Type 3 | 1 | 1 | |
Type 4 | 1 | 1 | 1 |
I thought Mapping would work, but there seems to be a conflict when the same type rolls up into the same name.
Any Ideas?
Many Thanks...Again
Kozan
Post your script..
Regards,