Set Analysis - Simple Issue!

[#1]

Hi All,

I have the following syntax which I'm using to create a variable named MaxMonthYear, I want to find the maximum in the fields that don't contain Projection or MTP as their year indicator.

Can anyone out there see the issue?

=(max({$<YearIndicator-={'Projection', 'MTP'}>}num(MonthYear)))

Any help is greatly appreciated.

[Gysbert_Wassenaar]

I don't see the issue. Can you post a qlikview document that demonstrates the problem?

[#3]

That's what I was afraid of , the app is absolutely huge and jammed full of DPA breaches, I won't be able to easily attach a version of it.

[Gysbert_Wassenaar]

See this document: Preparing examples for Upload - Reduction and Data Scrambling

[chrismarlow]

Are you using this as an expression or in a variable? If a variable do you not have to change the set analysis to an IF statement?

[#6]

It's in a variable, this isn't something I've heard of but by the power of Greyskull I'll give it a go!

[chrismarlow]

Ignore that, I learn something new every day . When you say contain do you mean are exactly or are like?

[#8 · Accepted solution]

Fixed it, the set was actually working the month out correctly, I had however missed the fact that I needed to add similar syntax to the year indicator field within the expression too

[menta]

=num((max({$<YearIndicator=-{'Projection', 'MTP'}>} MonthYear)))