Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Simple Issue!

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

8 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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


talk is cheap, supply exceeds demand
chrismarlow
Specialist II
Specialist II

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?

Not applicable
Author

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
Specialist II
Specialist II

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

Not applicable
Author

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
Partner - Creator II
Partner - Creator II


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