Workaround for selecting calculated dimension?

asamariaekrickl — Tue, 18 Aug 2020 04:34:28 GMT

I have a calculated dimension which looks like this:

=if(IPLOS <= $(vNSWIPALOS) / 3 ,Dual('Short',2),
if(IPLOS > $(vNSWIPALOS) / 3.1 and IPLOS <= $(vNSWIPALOS) * 0.75 , dual('Short Inliers',1),
if(IPLOS > $(vNSWIPALOS) * 0.76 and IPLOS <= $(vNSWIPALOS) * 1.25 , dual('Within NSW Avg',3),
if(IPLOS > $(vNSWIPALOS) * 1.26 and IPLOS <= $(vNSWIPALOS) * 3 , dual('Long Inliers',5),
if(IPLOS > $(vNSWIPALOS) * 3.1 , Dual('Long',4))
))))

The dimension needs to be in the frontend as the variable vNSWIPALOS changes depending on user selections.

The requirement is that the users want to be able to select in the chart legend.

That is of course not possible with a calculated dimension but I just want to check with you to see if you have come up with a workaround for this?

Thanks in advance

Asa

Re: Workaround for selecting calculated dimension?

edwin — Thu, 17 Sep 2020 17:27:31 GMT

You must have clear picture of what you want to happen when the user does select each of these calculated values - perhaps set specific fields (set IPLOS mabe?).

create an inline table that is not connected to any other tables with these values. present it as a list then in triggers, set the specific fields (IPLOS or whatever).

topic Re: Workaround for selecting calculated dimension? in QlikView

Workaround for selecting calculated dimension?

Re: Workaround for selecting calculated dimension?