topic Re: Set analysis in QlikView

Set analysis

Wed, 25 Nov 2020 16:16:04 GMT

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

Gysbert_Wassenaar — Mon, 31 Oct 2016 17:00:07 GMT

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

Mon, 31 Oct 2016 17:37:48 GMT

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

Mon, 31 Oct 2016 17:48:57 GMT

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)

Mon, 31 Oct 2016 23:32:27 GMT

Hi John,

Can you upload qvw?