Number formatting and set analysis

Thu, 28 Jun 2012 08:28:00 GMT

Hi,

I am using an expression to set the format of certain cells, this works fine. In the expression there is also a set analysis to ignore certain selections. This works also fine.

However when a selection is done in a field which is ignored by the set analysis the formatting disappears expect for the selected value.

Below is a shortened version of the expression:

if(Ratio=20, Money(sum({$<Specialisme_omschrijving_conc=>}noemer),'€ #.##0'),

if(Ratio=23, num(sum({$<Specialisme_omschrijving_conc=>}noemer),'#.##0,0%')

))

So when a selection is done in the field Specialisme_omschrijving_conc the selection is ignored (as it should), however the formatting disappears except for the selected value of Specialisme_omschrijving_conc.

Does anyone know how to fix this. I want to keep the formatting for all dimension not just the selected one.

gr.

Frank

Re: Number formatting and set analysis

skovsgaard — Fri, 17 Aug 2012 06:34:24 GMT

Hi Frank

Have the exact same issue - a shame no one have come with a solution to your issue.

Regards

Soren

topic Number formatting and set analysis in QlikView

Number formatting and set analysis

Re: Number formatting and set analysis