Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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.