topic Re: Pivot table - dimension in row in QlikView

Pivot table - dimension in row

Tue, 01 Apr 2014 08:03:23 GMT

Dear community,

In pivot table, how can i show only one "2008" at the top row (By Year)?

Thanks and best regards,

Chanel

Re: Pivot table - dimension in row

its_anandrjs — Tue, 01 Apr 2014 08:06:35 GMT

You can write like

sum({<Year = {2008} >} Sales)

in this you get only 2008 data

Hope this helps

Re: Pivot table - dimension in row

Tue, 01 Apr 2014 08:44:43 GMT

Thanks for your reply but sorry that miss attached the image.

I just want to show 2008 once, instead of showing in each column...

Re: Pivot table - dimension in row

sujeetsingh — Tue, 01 Apr 2014 09:00:17 GMT

Just try using PIVOT selected

Re: Pivot table - dimension in row

its_anandrjs — Tue, 01 Apr 2014 09:29:12 GMT

Hi,

If data for months is for same month like for 12 months then year will be single cell i suggest once try to make a pivot chart again and if possible provide sample application with few data and with pivot table.

Thanks & Regards

Re: Pivot table - dimension in row

Tue, 01 Apr 2014 14:07:19 GMT

Thanks for your response again.

I have solved this by having formula at Year dimension.

example formula: =if(Year >= $(=max({1} Year))-2, Year)

Re: Pivot table - dimension in row

Tue, 01 Apr 2014 14:08:52 GMT

I have solved this by having formula at Year dimension.

for extra knowledge, would you share what is PIVOT selected?

Any button or setting that i should configure?

Re: Pivot table - dimension in row

Tue, 01 Apr 2014 15:23:32 GMT

In Presentation properties, you will have a option as 'Allow Pivoting' with checkbox...

If you enable it, you can drag the dimensions and expressions in horizontal or vertical alignment.

Re: Pivot table - dimension in row

Wed, 02 Apr 2014 04:06:46 GMT

thanks for your explanation but this is not my question. Anyhow, i have solved it!