Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
asamariaekrickl
Partner - Contributor III
Partner - Contributor III

Workaround for selecting calculated dimension?

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.

Annotation 2020-08-18 113155.png

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

1 Reply
edwin
Master II
Master II

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).