Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

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
Partner

Try this
sum({<month_num={">=$(fixed_start_month) <=$(max({<man_days_type={"planned"}>} month_num))"} man_days)
ali_hijazi
Partner
Partner
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
Partner
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.