Is this because of set analysis again??? - Qlik Community

Report Inappropriate Content · ‎2011-07-21

Hi all:

I am able to get the following working in Qlikview 10 but when i try to get in working in Qlikview 7.5 it just not able to work.

The Expression is:-

Sum({<Year={$(=vMaxYear)}, Month={$(=vMaxMonth)},Day={"<=$(=vMaxDay)"}>}[goodqty])

Is this due to the set analysis again that Qlikview 7.5 not able to perform?

Is there any other way to get this working in Qlikview 10?

Thanks for any help

kaushiknsolanki · ‎2011-07-21

Hi,

As par my knowledge set analysis is not supported in qlikview 7.5 and because of that you are getting problem.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-07-21

Hi Kaushik:

Yup i think so...

Just too bad that the company is not going to change to Qlikview 10 so I have to work with Qlikview 7.5

Do you have any idea how to get around this issue?

Thanks for the reply.

martin59 · ‎2011-07-21

Hi,

Set Analysis appaered in QV 8.5, so if you use an older version, you have to use if() functions like this :

Sum(if(Year=$(vMaxYear) and Month=$(vMaxMonth) and Day<=$(vMaxDay), [goodqty]))

Hope that helps you

Martin

rahulgupta · ‎2011-07-21

Hi,

You can use it in the If Clause:

=Sum(If(Year=$(vMaxYear), if(Month=$(vMaxMonth), if(Day<=$(vMaxDay),[goodqty])))

Hope this helps

Regards