topic Re: Assigning headers to multiple columns in pivot table in QlikView

Assigning headers to multiple columns in pivot table

Fri, 20 Nov 2020 18:02:30 GMT

Hello,

For the pivot chart, i have one dimension and 4 calculated expressions:

On selection of multiple months for example, Jan and Feb in year 2014, the pivot table gives me sum of both, is it possible to break the values monthwise in pivot/straight table as reflected in below diagram and then finding the TOTAL value for both the months.

Thanks

Re: Assigning headers to multiple columns in pivot table

Clever_Anjos — Tue, 07 Oct 2014 13:24:44 GMT

To do that you should have two dimensions, Brand and Month.

Then Pivot your table, dragging the column to upper size and then at Presentation tab mark "Subtotal" for any column you want

Re: Assigning headers to multiple columns in pivot table

Tue, 07 Oct 2014 13:34:56 GMT

Thanks,

on selection of september 2013 and july 2013 , it gives me all possible months of 2013 having values present and it doesnt give me the total of september + july 2013

Re: Assigning headers to multiple columns in pivot table

Clever_Anjos — Tue, 07 Oct 2014 13:40:31 GMT

I´m seeing a horizontal scrollbar, isn´t it at right side?

Please check at Presentation Tab if field Month_Name is market to Aggr

Re: Assigning headers to multiple columns in pivot table

Tue, 07 Oct 2014 13:49:45 GMT

thanks

still not sure why august data is reflecting!

Re: Assigning headers to multiple columns in pivot table

Clever_Anjos — Tue, 07 Oct 2014 13:56:55 GMT

Could you check your expressions and fields Month_Name? Maybe there´s some relation between August month

Which field are you using to select? Same Month_Name?

Re: Assigning headers to multiple columns in pivot table

Tue, 07 Oct 2014 14:01:38 GMT

expressions are fine. and on selection of month names september and october in year 2013. it shows me july + august+ september+ october data.

for 2013 year , there isnt data available from jan to june. so it provides me all months value prior to selected months