Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Eu preciso colocar o mês na análise definida abaixo. usando o Pick

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.....

2020-04-25_16-47-24.png

Desired result:

2020-04-25_16-48-39.png

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

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!

View solution in original post

1 Reply
Highlighted
Contributor II
Contributor II

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!

View solution in original post