topic Re: Set analysis within set modyfier in QlikView

Set analysis within set modyfier

sibrulotte — Wed, 10 May 2017 18:25:36 GMT

hi,

I have a set analysis that works well:

=maxstring({<[Période fermée] ={'1'}>}[Année-période financière])

This gives me 2017-09. basically, year 2017, 9th period. 9th period in my calendar is january.

I want to bring back january as my result so I tried this set analysis:

=only({< [Année-période financière]={'$(maxstring({<[Période fermée] ={'1'}>}[Année-période financière]))'}>} Mois)

Gives me a blank in a text box. Is there something I'm not writting properly in my expression?

sunny_talwar — Wed, 10 May 2017 18:43:52 GMT

May be this

=Only({<[Année-période financière]={"$(=MaxString({<[Période fermée] ={'1'}>}[Année-période financière]))"}>} Mois)

sibrulotte — Wed, 10 May 2017 18:45:27 GMT

Ah this is why I need te revise my expressions. The = was missing in front of Maxstring in deed..

thanks

sunny_talwar — Wed, 10 May 2017 18:47:51 GMT

And the double quotes, or remove the inner single quotes and then you can use single quotes