Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

who is expert in set analysis

Hello I need an answer on set analysis syntax

I got a pivot table and 2 expressions
expression 1 is max({<man_days_type={"planned"}>} month_num)
expression 2 is sum({<month_num={">=$(fixed_start_month)"} man_days)

however in expression 2 I want to also include that month_num is <= to the value calculated in expression 1
kindly advise

 

I can walk on water when it freezes
5 Replies
arpitkharkia
Creator III
Creator III

Create a variable and set the value as that of the first expression. Use the variable in the set analysis for the second expression.

raman_rastogi
Partner - Creator III
Partner - Creator III

Try this
sum({<month_num={">=$(fixed_start_month) <=$(max({<man_days_type={"planned"}>} month_num))"} man_days)
ali_hijazi
Partner - Master II
Partner - Master II
Author

doesn't work as this requires a one value whereas the max value changes between values of the dimension

I can walk on water when it freezes
ali_hijazi
Partner - Master II
Partner - Master II
Author

the value is a table and not one value; it changes on rows; so doesn't work

I can walk on water when it freezes
sunny_talwar

If this is based on row value, then set analysis is not going to work because set analysis is performed at a chart level and not at a row level. May be use Aggr() function with an if condition.