topic Re: Help with expression in QlikView

Help with expression

Sun, 16 Dec 2012 06:32:37 GMT

Hi All...

I am trying to show Quarter over Quarter growth between two Quarters of different years ... 2012 Q3 vs 2011Q3

I have to use two dimensions... dimensin "vendor" displayed vertical and dimension "Quarter" displayed horizontal

The expression for Quarterly share is

=num(sum(Units) / Sum(TOTAL <Quarter> Units),'#.##%')

Now i have to show an expression(QoQ) for 2012Q3 Quarterly share vs 2011Q3 Quarterly Share(Quarter over Quarter growth for 2012Q3 vs 2011Q3)

Please find attached Qvw and Sample data

Appericate help on this

Sun, 16 Dec 2012 06:33:51 GMT

Sun, 16 Dec 2012 06:34:32 GMT

Please click on the image to enlarge

SunilChauhan — Sun, 16 Dec 2012 12:16:03 GMT

use below code for qoq

sum(Units)

Sum(TOTAL Units)

or please get back if you need any thing else

sujeetsingh — Mon, 17 Dec 2012 07:23:46 GMT

num(sum(Units)/Sum({<Year={$(=Left(Quarter,4)-1)} TOTAL <Quarter> Units))

try some thing like this

jagan — Mon, 17 Dec 2012 18:07:03 GMT

Hi Ganesh,

If you have a date field in your data model, for example date field name is BilledDate, the try this expression

2012Q3 = Sum({<BilledDate={'>=$(=QuarterStart(Max(BilledDate), -1))<=$(=QuarterEnd(Max(BilledDate), -1))}>} Sales)

2011Q3 = Sum({<BilledDate={'>=$(=QuarterStart(Max(BilledDate), -5))<=$(=QuarterEnd(Max(BilledDate), -5))}>} Sales)

The above expressions gets you the Sales for quarters 2012Q3 and 2011Q3. Hope this helps you.

Regards,

Jagan.