topic Re: Set analysis in a simple table: How to do refer to chart dimensions? in QlikView

Set analysis in a simple table: How to do refer to chart dimensions?

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

Hi Guys,

I need to compare annual data and wanted to have a simple table with the sum(Amount) of each year and the sum of last year, while the year is one of the chart dimensions.

I tried to calculate the sum of each last year for each year in the dimension as

sum({$<Year= {"$(=$(Year)-1)"}>} Amount)

It does not work. But why and what would be right solution?

I have attached a small example to your convience.

Thanks,

Andreas

Re: Set analysis in a simple table: How to do refer to chart dimensions?

maxgro — Sun, 29 Jan 2017 13:14:19 GMT

maybe with this expression

above(sum(Amount))

Re: Set analysis in a simple table: How to do refer to chart dimensions?

vinieme12 — Sun, 29 Jan 2017 13:24:34 GMT

Rangesum(Sum(Amount),above(sum(Amount)))

Re: Set analysis in a simple table: How to do refer to chart dimensions?

sunny_talwar — Sun, 29 Jan 2017 13:34:59 GMT

Or this if you plan to make selections

Above(Sum({<Year>}Amount)) * Avg(1)

Without Selection

With Selection

Re: Set analysis in a simple table: How to do refer to chart dimensions?

andreas_koehler — Mon, 30 Jan 2017 08:18:04 GMT

Thanks Massimo,

I had forgotten this expression. Your was the first answer that resolved the initial problem.

Selecting years is a problem though.

Andreas

Re: Set analysis in a simple table: How to do refer to chart dimensions?

andreas_koehler — Mon, 30 Jan 2017 08:58:26 GMT

Thanks Sunny,

Above(Sum({<Year>}Amount)) * Avg(1)

So by adding the "empty expression" of Avg(1), for which the selection"year" is not disregarded, the whole expression becomes filtered by the selection again?

Nice trick.

Thanks

Andreas

Re: Set analysis in a simple table: How to do refer to chart dimensions?

sunny_talwar — Mon, 30 Jan 2017 10:09:30 GMT

Yes sir...

Re: Set analysis in a simple table: How to do refer to chart dimensions?

andreas_koehler — Mon, 30 Jan 2017 10:56:20 GMT

Hi Guys,

thanks for all your help.

Please find an updated version of the example with all the answers side-by-side.

Re: Set analysis in a simple table: How to do refer to chart dimensions?

sunny_talwar — Mon, 30 Jan 2017 10:58:45 GMT

Are you just compiling and sharing our responses or is there a question for us ?

Re: Set analysis in a simple table: How to do refer to chart dimensions?

andreas_koehler — Thu, 09 Mar 2017 14:07:03 GMT

Just sharing. My attempt to give something back to the community.