Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this set analysis using PICK (MixMatch ... It's working. I would like to put it on Jan, Feb, Mar. Create set analysis using the set analysis below.
Set analysis:
PICK( MixMatch(ORDEM1,
$(=Concat({<ORDEM1 -= {''}>}DISTINCT chr(39) & ORDEM1 & chr(39),',',ORDEM1))
),
$(vVariavel1),$(vVariavel2),$(vVariavel3) )
I need to fill the month Jan, Feb, Mar (PICK( MixMatch.....
Desired result:
https://community.qlik.com/t5/New-to-Qlik-Sense/filter-a-variable/td-p/1416200
sum({<Ano={$(=Max(Ano))},[Mes]={'Jan'}>}Aggr($(vExpressao1), Ano,Mes))
Obrigado!
https://community.qlik.com/t5/New-to-Qlik-Sense/filter-a-variable/td-p/1416200
sum({<Ano={$(=Max(Ano))},[Mes]={'Jan'}>}Aggr($(vExpressao1), Ano,Mes))
Obrigado!