Is this because of set analysis again???

[#1]

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]

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

[#3]

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]

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]

Hi,

You can use it in the If Clause:

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

Hope this helps

Regards