topic Re: Expression Issue in QlikView

Expression Issue

vipin_mishra479 — Tue, 13 Aug 2013 12:02:55 GMT

Hi All,

here i attached exl and qvw file.

my problem is that i have fixed the dimenssion eg(Apr 2013)

and in expression i have written Sum(qty)

then it show Apr 2013 Sum(qty)

but my requirment is for fixed dimension eg(Apr 2013)

i need in expression Apr 2013 Sum(qty) as well as

Apr 2012 Sum(qty)

please help...!!!

Re: Expression Issue

Gysbert_Wassenaar — Tue, 13 Aug 2013 12:26:06 GMT

You can't use the MonthYear field that way in both the calculated dimension and the set analysis expression. What you can do is remove the calculated dimension and use two set analysis expressions that both are fixed to a specific month:

2013: sum({<MonthYear = {'Apr 2013'}>}qty)

2012: sum({<MonthYear = {'Apr 2012'}>}qty)

See attached qvw.

Re: Expression Issue

vipin_mishra479 — Tue, 13 Aug 2013 13:02:22 GMT

Hi Gysbert ,

thanks for the reply

i want to make it dynamic as per your solution for every month i have to write a expression , which is not feasible.

so please tell any other way

Actually what i want

Dimension ->

month year Apr 2013

expresion sum(<Apr 2013>qty) * sum(<Apr 2012>qty)

in the same way for May 2013 and so on.