topic Re: Set Analysis - Simple Issue! in QlikView

Set Analysis - Simple Issue!

Thu, 26 Feb 2015 15:51:40 GMT

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.

Re: Set Analysis - Simple Issue!

Gysbert_Wassenaar — Thu, 26 Feb 2015 15:55:37 GMT

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

Re: Set Analysis - Simple Issue!

Thu, 26 Feb 2015 15:57:32 GMT

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.

Re: Set Analysis - Simple Issue!

Gysbert_Wassenaar — Thu, 26 Feb 2015 16:00:17 GMT

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

Re: Set Analysis - Simple Issue!

chrismarlow — Thu, 26 Feb 2015 16:01:07 GMT

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?

Re: Set Analysis - Simple Issue!

Thu, 26 Feb 2015 16:02:39 GMT

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!

Re: Set Analysis - Simple Issue!

chrismarlow — Thu, 26 Feb 2015 16:04:32 GMT

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

Re: Set Analysis - Simple Issue!

Thu, 26 Feb 2015 16:13:58 GMT

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

Re: Set Analysis - Simple Issue!

menta — Thu, 26 Feb 2015 16:24:20 GMT

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