Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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).