topic Re: Pivot Table to Chart in QlikView

Pivot Table to Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to convert this Pivot table (See screenshot below) to a chart?

Dimensions:

State

EndDate_YYYYMM

Expressions:

Count({<[ENDDATE_YYYY] -= {"3000"}>}ID)

If(RowNo() <= 3, Num(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID)/

Below(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID), 1) - 1, '#.00%'))

sunny_talwar — Mon, 23 Jan 2017 19:59:31 GMT

Pivot table to a chart? Pivot table is also a chart... what exactly do you mean?

Anonymous — Mon, 23 Jan 2017 20:02:04 GMT

I would like to turn the pivot table into a bar chart but I have multiple dimensions (State and EndDate) and I'm not sure if that's possible.

sunny_talwar — Mon, 23 Jan 2017 20:05:12 GMT

May be this:

Aggr(

If(RowNo() <= 3, Num(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID)/

Below(Count({<[ENDDATE_YYYY] -= {"3000"}>}ID), 1) - 1, '#.00%'))

, State, EndDate_YYYYMM)

MK9885 — Mon, 23 Jan 2017 20:38:42 GMT

Do you mean by 'Fast Change'?

Same chart but different views?