topic Re: How to create constant value in Qlikview in QlikView

How to create constant value in Qlikview

Mon, 26 Jan 2026 18:19:17 GMT

I want to define a constant value in Qlik that contains the total of a field. This value which will be contained in a text object will not change when user clicks various drop-down items.. I want to be able to use this constant value in further calculations.

Thanks,

Re: How to create constant value in Qlikview

Frank_Hartmann — Thu, 20 Jul 2017 14:05:25 GMT

see attached file

hope this helps

Re: How to create constant value in Qlikview

Thu, 20 Jul 2017 14:07:34 GMT

ok. Is this called set analysis ?

Re: How to create constant value in Qlikview

Frank_Hartmann — Thu, 20 Jul 2017 14:20:25 GMT

Its called Set Identifiers:

Examples:

sum( {$} Sales )
returns sales for the current selection, i.e. the same as sum(Sales).

sum( {$1} Sales )
returns sales for the previous selection.

sum( {$_2} Sales )
returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two Back operations.

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.

sum( {1} Total Sales )
returns total sales within the application, disregarding both selection and dimension. I.e. the same as sum(All Sales).

sum( {BM01} Sales )
returns sales for the bookmark BM01.

sum( {MyBookMark} Sales )
returns sales for the bookmark MyBookMark.

sum({Server\BM01} Sales)
returns the sales for the server bookmark BM01.

sum({Document\MyBookmark}Sales)
returns the sales for the document bookmark MyBookmark.

Re: How to create constant value in Qlikview

vishsaggi — Thu, 20 Jul 2017 14:26:41 GMT

May be create a variable? Like

Click Ctrl+Alt+V then Add

Give a name like vTotalValue

= Sum({1} YourfieldHere)

Then use a textobject and type

= vTotalValue