Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would like to have some help in what I am trying to achieve here.
I have a data table like so:
Fields |
Export |
Patener |
Group |
RevenueGroup |
Type |
Other |
SF |
BSF |
MSF |
Client |
Group Client |
Excl |
and I would like to have my data to be displayed in a pivot table like so:
Dims | DimsValue | Fields |
1 | Partners | Export |
2 | Partners | Patener |
3 | Partners | Group |
4 | RevenueGroup | RevenueGroup |
5 | Type | Type |
6 | Agencies | Other |
7 | Agencies | SF |
8 | Agencies | BSF |
9 | Agencies | MSF |
10 | Clients | Client |
11 | Clients | Group Client |
12 | Titles | Excl |
but the Dims will be hidden or not added to the table.
I can do it with an if statement in the dimension but the table it very slow so I am thinking of doing it in the script but I can't figure out the best approach do it.
the if statement will be like so:
if(Dims=1,Export,if(Dims=2,Partner, and so on
I used an inline table to do it this but am not sure if there is a different way of achieving this in the script.
Kind Regards,
Ray
Forgot to add what it should look like with hidden Dims.
DimsValue | Fields |
Agencies | BSF |
MSF | |
Other | |
SF | |
Clients | Client |
Group Client | |
Partners | Export |
Group | |
Patener | |
RevenueGroup | RevenueGroup |
Titles | Excl |
Type | Type |
No idea if this is on the right track or not, but might be:
https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325
The base URL for the Design Blog area is:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
That is a great place to search for how-to and best practice related topics, sorry, I am not quite sure exactly what you want, but hopefully this gets you on the right track, and my post will kick things back up, but I cannot say if anyone else will shout or not.
Regards,
Brett