topic Re: display multiple dimensions in one dimension based on ifs in QlikView

display multiple dimensions in one dimension based on ifs

rkhadraoui1016 — Wed, 09 Oct 2019 13:30:05 GMT

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

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

Re: display multiple dimensions in one dimension based on ifs

rkhadraoui1016 — Wed, 09 Oct 2019 13:33:08 GMT

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

Re: display multiple dimensions in one dimension based on ifs

Brett_Bleess — Mon, 14 Oct 2019 20:16:04 GMT

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