topic Re: Fix a chart to YTD in QlikView

Fix a chart to YTD

chiso_chiso — Wed, 17 Dec 2014 09:29:51 GMT

Gurus,

Kindly assist, how do i fix a chart to only show YTD values and that it should not change despite other selections i.e. month?

Re: Fix a chart to YTD

Michiel_QV_Fan — Wed, 17 Dec 2014 09:35:34 GMT

With set analysis you can exclude specific fields from the expression

For instance sum({<Month>}amount) calculates the amount for all other selections but ignores a month selection.

You will see the same also writen as sum({<Month =>}amount). The = isn't necessary, the result is the same.

Help text:

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value.

Re: Fix a chart to YTD

chiso_chiso — Wed, 17 Dec 2014 09:47:17 GMT

Thanks MichielvandeGoor