Qlikview 10 and qlikview 7.5

[#1]

Hi everyone:

The following code for Expression under Opening Balance for Qlikview 10 works just fine but when I transfer the code to Qlikview 7.5 the figures for Opening balance does not seem to appear.

=sum({<invtype ={20}>} goodqty) - sum({<invtype ={34}>} goodqty)

+

sum({<invtype ={40}>} goodqty) - sum({<invtype ={42}>} goodqty)

Could anyone share some light to this?

Thanks alot 

[rwunderlich]

Your expressions use Set Analysis syntax -- which was not available until QV 8.5.

-Rob

http://robwunderlich.com

[#3]

Hi Rob:

Thanks for the information. Now I know why I can’t get the Expression in Qlikview 7 because of the SetAnalysis syntax problem.

Is there another way of getting over this SetAnalysis syntax in Qlikview 7?

Thanks a lot

[#4]

Hi,

   Try with "If" statement instead of Set Analysis.As told earlier QV 7 wont support Set Analysis.

-Jai

[#5]

Hi Jai:

Thanks for the reply.

I am not too sure how I can use the ‘if’ statement for the below statement.

= sum({<invtype = {20}>}goodqty) -  sum({<invtype = {34}>}goodwty)

+

sum({<invtype = {40}>}goodwty) - sum({<invtype = {42}>}goodwty)

There are two fields’ invtype and goodqty:-

I need to sum the goodqty under invtype ‘20’ – sum the goodqty under ‘34’ + sum the goodqty ‘40’ – sum the goodqty under invtype ‘42’

Sorry for the trouble as I am new to script or code writing.

Thanks a lot for all your kind help.

[#6 · Accepted solution]

Hi Jai and Rob:

I manage to use the following 'If' statment and it works....

sum (if (invtype='20',goodqty)) - sum (if (invtype='34',goodqty))

+

sum (if (invtype='40',goodqty)) - sum (if (invtype='42',goodqty))

Guys thank you so much for your kind help...