topic Re: Set Analysis in Chart Dimension in QlikView

Set Analysis in Chart Dimension

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

I need a chart, that use all years in my data, unless a selected year.

Can i use a Set Analysis as Chart Dimension overriding selected years?

In example above, i have a table with values of the last 6 years.There i'm working with set analysis. This works. Now i want to draw a chart (line or bar) with the dimension "YEAR", but in the chart, the selection of the year 2017 should be overriden, like the straight table.

Thank for your help!

Rolf

Re: Set Analysis in Chart Dimension

sunny_talwar — Sun, 09 Apr 2017 01:48:22 GMT

May be like this

Sum({<Jahr>}Netto_Nettowert)

Re: Set Analysis in Chart Dimension

passionate — Sun, 09 Apr 2017 03:43:59 GMT

Hi,

You can use Sum({<Year= >}Sales) in your Expression.

This will not consider your year selection.

Please confirm if this is what you wan't.

Cheers,

Pankaj

Re: Set Analysis in Chart Dimension

ecolomer — Sun, 09 Apr 2017 15:49:51 GMT

Is this you need?