Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

show totals but suppress values in pivot table

Hi

I have a pivot table as shown below. What I need is to suppress the YTD column and just show the total.

YTD.png

13 Replies
sunny_talwar
Not applicable

Re: show totals but suppress values in pivot table

Would you be able to share your qvw?

Not applicable

Re: show totals but suppress values in pivot table

Sorry, I could not as the data is Sensitive.

It's pretty Straight forward, two dimensions Year and month

Service % is the measure calculated by the formula Supply/Demand per month

YTD is just an extension of that.

Clever_Anjos
Not applicable

Re: show totals but suppress values in pivot table

I don´t think you can have 1 column at detail and 2 columns at total

sunny_talwar
Not applicable

Re: show totals but suppress values in pivot table

I think we might be able to use Synthetic dimensions or Island table dimension to do this. I was just hoping to see how the data is structured to give any suggestions.

sunny_talwar
Not applicable

Re: show totals but suppress values in pivot table

You can always scramble your data as mentioned here: Preparing examples for Upload - Reduction and Data Scrambling

Anyways, I will create a sample for you and you can check if this works for you or not

sunny_talwar
Not applicable

Re: show totals but suppress values in pivot table

Have a look here:

Capture.PNG

Clever_Anjos
Not applicable

Re: show totals but suppress values in pivot table

Very tricky and smart, congrats

sunny_talwar
Not applicable

Re: show totals but suppress values in pivot table

Thanks Clever. I think the dimension and expressions are still not perfect because I am not seeing the accumulation, but it can be further fine-tuned to get the desired result

sunny_talwar
Not applicable

Re: show totals but suppress values in pivot table

This is slightly better now

Capture.PNG