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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to use set analysis to limit dimension

Currently this is the expression I am using.

=((if(caploaddate=if(GetFieldSelections([Load Date])='Today',today(),If(GetFieldSelections([Load Date])='Tomorrow',today()+1,if(GetFieldSelections([Load Date])='Day After Tomorrow',today()+2,if(GetFieldSelections([Load Date])='Three Days',today()+3,if(GetFieldSelections([Load Date])='4 Days',today()+4))))),cap)))

Currently this is changing when other selections are made. How would I go about telling the dimension to only look at the field [Load Date]?

I want the chart to only display based on an inline table that I have set to always 1 selected. Hence the long code, where I do not want it to affect other data.

1 Solution

Accepted Solutions
Not applicable
Author

Discovered it would just be easier to disconnect the tables I am using from the other tables. This broke the link so now the data is independent.

View solution in original post

1 Reply
Not applicable
Author

Discovered it would just be easier to disconnect the tables I am using from the other tables. This broke the link so now the data is independent.