topic Re: Freeze the values in Chart table in QlikView

Freeze the values in Chart table

Wed, 04 Dec 2013 13:01:52 GMT

Hi,

I need to freeze the values in a field in a chart table. If i select any input in the multibox, the values in that field should not change.

Re: Freeze the values in Chart table

marcus_malinow — Wed, 04 Dec 2013 13:06:56 GMT

Hi chaithra,

this sounds like the sort of issue you'd be able to tackle using set analysis.

If, for example your original expression was sum(Sales), and you wished to ignore the selection in a field called 'IgnoreThisField', then change your expression to:

sum({$<IgnoreThisField=>} Sales)

Marcus

Re: Freeze the values in Chart table

MK_QSL — Wed, 04 Dec 2013 13:10:01 GMT

Marcus's answer is right if you want your sales value not to change on selecting those field.

SUM({<Year = , Month = , Qtr = , >}Sales)

This will give you same result if you change Year, Month or Qty...

If you want your sales not to change even though change in any field or list box... use below.

SUM({1}Sales)

Re: Freeze the values in Chart table

brijesh1991 — Thu, 05 Dec 2013 05:35:49 GMT

Go to Document Properties---> General----> Alternate States----> Add---> Give a name to State for example give the name "a". ----OK

Now go to your chart properties--->General---->Alternate State---> Select "a"---Apply

Now your values won't change with other selections. . .

Regards,

Brijesh

Re: Freeze the values in Chart table

Thu, 05 Dec 2013 13:25:46 GMT

Thank u, it worked