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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pinkal_Shah
Contributor
Contributor

Alternate State+Set Analysis+Variable

I want to calculate the sum of a few dimensions in alternate state and over that, i want to complete calculation by choosing one variable from filter pane. My current expression is 

=Sum({[State1]<User_Dimension= {'Active'},Value_Dimension = {'Total'},Value_Type={'Combined'},Time_Dimension = {'$(vTimeDimension)'}>} Value_Entry)

=Sum({[State2]<User_Dimension= {'Active'},Value_Dimension = {'Total'},Value_Type={'Combined'},Time_Dimension = {'$(vTimeDimension)'}>} Value_Entry)

and in which state i should keep filter pane.

 

Please suggest which approach i should to try to execute my expression.

Thank You

Labels (3)
0 Replies