topic Re: Month Selection not working in QlikView

Month Selection not working

kushalthakral — Mon, 28 Apr 2014 08:34:48 GMT

Dear All

i have data for two months

when ever i select Jan or Feb it showing correct results but when i select both month it is showing different result not month wise

say i have

Model Month Sales

A Jan 100

B Jan 20

A Feb 200

B Feb 40

When ever i select Jan it shows A 100 and B 20 and for Feb it shows A 200 and B 40

But i waana show it like

Model	Jan	Feb
A	100	200
B	20	40

But i m getting wrong result in this

Thanks

Kushal Thakral

Re: Month Selection not working

MK_QSL — Mon, 28 Apr 2014 08:40:24 GMT

Check enclosed file..

Re: Month Selection not working

kushalthakral — Mon, 28 Apr 2014 08:45:11 GMT

Dear Manish

You have written two different folrmulaes for Jan and Feb month

But i want to automate this process

means every month new column added and figures shows there

Regards

Kushal

Re: Re: Month Selection not working

MK_QSL — Mon, 28 Apr 2014 08:51:17 GMT

Like this?

Re: Month Selection not working

Mon, 28 Apr 2014 08:55:58 GMT

Check the attachment.

Re: Month Selection not working

Mon, 28 Apr 2014 09:03:42 GMT

You could just put it in a pivot table with 2 dimensions (Model followed by Month) and sum(Sales) as the expression. Once the table is populated you can drag it on top of the expression and view as many months as required.

Re: Month Selection not working

MK_QSL — Mon, 28 Apr 2014 09:03:55 GMT

Try below also...

and let me know whether this is what you are looking after?

SUM({<YearMonth = {'<=$(=Max(YearMonth))'}>}Sales)