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
