topic Re: Pivot table in QlikView

Pivot table

Anonymous — Wed, 19 Nov 2014 12:41:29 GMT

Hello

I have table like

Yr, Value

2014, 100

2013, 200

2012, 300

2011, 100

i want to create pivot table that has show only 2014 and 2013

Year Amt

2014 100

2013 200

regards

ramu

Re: Pivot table

PrashantSangle — Wed, 19 Nov 2014 12:46:07 GMT

Hi,

Use calculated Dimension

if(wildmatch(Year,'2014','2013'),Year)

And select Supress Null Value in Dimension

And take Amt as Expression

Regards

Re: Pivot table

ashfaq_haseeb — Wed, 19 Nov 2014 12:46:59 GMT

Try like this

load * Inline

[

Yr, Value

2014, 100

2013, 200

2012, 300

2011, 100

] Where Yr>=2013;

Regards

ASHFAQ

Re: Pivot table

Wed, 19 Nov 2014 12:49:14 GMT

Add year in the dimension and use set analysis in the expression to get the desired output.

Expression:

Sum({<Year={'2013','2014'}>}Value)

Re: Pivot table

Anonymous — Wed, 19 Nov 2014 12:56:58 GMT

Hi ,

Please find Solution below.

Re: Pivot table

Anonymous — Wed, 19 Nov 2014 12:58:27 GMT

Thanks sampath

I also have another dim column to group the table. if I make the year field drag to column level I am getting message that "Allocated memory exceed". Can you please help me on this.

regards

ramu

Re: Pivot table

Anonymous — Wed, 19 Nov 2014 13:00:37 GMT

Thanks sampath

I also have another dim column to group the table. if I make the year field drag to column level I am getting message that "Allocated memory exceed". Can you please help me on this.

regards

ramu