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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis

Hi All,

I have a set expression

Sum({$<MonthYear=>}sales)

now i want  to add a flag to it  MYflag ={'1'}

How can i add it

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Sum({$<MonthYear=, MYflag ={'1'}>}sales)


talk is cheap, supply exceeds demand
Not applicable
Author

Hi gysbert

when i'm giving the flag my chart is showing no data to disaplay

My problem started here

in the below thread can you please help me out

Aggregations and Function Classes

Not applicable
Author

The problem in chart

when i'm selecting the Asof month i'm not getting the correct results

When i'm selecting the asof month and monthyear i'm getting the correct results

Below are the dimensions and expressions used

DIM1 Monthyear

DIM2 =Aggr(If(Rank(Sum(sales),4,1)<=5,country),country)

expression

Sum({$<MonthYear=>}sales)

Not applicable
Author

Hi John,

Can you upload qvw?