topic Re: dynamic columns in Straight/pivot table chart in QlikView

dynamic columns in Straight/pivot table chart

Krish — Fri, 15 Nov 2024 23:16:51 GMT

Hi,

I am trying to create a chart/table which has 2 dimensions, country and type and a measure sum(sales). My input would be like

and output like below

How can this be achieved?

Re: dynamic columns in Straight/pivot table chart

NITROG3NN — Thu, 21 Jan 2021 07:22:55 GMT

Hey Krish,

Try using Pivot chart and just drag the Dept column above your expression and you will get what you want. Check the attachments.

Re: dynamic columns in Straight/pivot table chart

Krish — Thu, 21 Jan 2021 08:34:44 GMT

This is what I was looking for. Thank you.

Is there a way to suppress Dept (field name header) from the pivot ?

Re: dynamic columns in Straight/pivot table chart

NITROG3NN — Thu, 21 Jan 2021 09:18:57 GMT

You cant suppress it fully, but try this, reduce the size of the column and label it blank in dimension tab (use space, screenshot attached below) and you will be left with the screenshot below.

Re: dynamic columns in Straight/pivot table chart

NITROG3NN — Thu, 21 Jan 2021 09:42:15 GMT

If the topic is resolved please mark the right answer.