Calculated dimension with a filter

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all, today in my calculated expression i have this

if($(vDay) = 1, FLAG, Aggr(If(Count(DISTINCT {<FLAG = {'NO COMP'}>}FLAG)/Count(DISTINCT {<FLAG = {'NO COMP','COMP'}>}FLAG) > 0.10, 'NOCOMP', FLAG), DEV_ID_LOC, DEPADR_PAYS_LIB, MAG_LIBELLE, JOUR_ID))

I want to change it like this

If ($(vDay) = 1

Get the value of FLAG where {<FILTER_JOUR_ID = {"$(=$(vNdebut))"}>}

Else

Aggr(If(Count(DISTINCT {<FLAG = {'NO COMP'}>}FLAG)/Count(DISTINCT {<FLAG = {'NO COMP','COMP'}>}FLAG) > 0.10, 'NO COMP', FLAG), DEV_ID_LOC, DEPADR_PAYS_LIB, MAG_LIBELLE, JOUR_ID))

only for the period selection in [Groupe1]* $}

A bit confused, Please hint me

Thanks in advance

Re: Calculated dimension with a filter

Anonymous — Tue, 23 Aug 2016 09:07:18 GMT

I tied this for the first part unfortunately it did not work

if($(vDay) = 1, only({<FILTER_JOUR_ID = {"$(=$(vNdebut))"}>}FLAG),

2nd try

if($(vDay) = 1, only({<FILTER_JOUR_ID = $(vNdebut)>}FLAG)

3rd try

if($(vDay) = 1, if(FILTER_JOUR_ID ={"$(=$(vNdebut))"},FLAG,null())

This is for informaiton

topic Re: Calculated dimension with a filter in QlikView

Calculated dimension with a filter

Re: Calculated dimension with a filter