topic Re: Calculated Dimension help in QlikView

Calculated Dimension help

jarrad_murray — Thu, 11 Jul 2013 11:44:30 GMT

Hi All,

I have an if statement with an embedded number function to display a dimension as either an integer or a percentage. The code that I am using for this is =if(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target,'#,##0')).

The problem that I am facing is that a couple of the figures that should be coming out as numbers are coming through as percentages.

Does anyone know if I am doing something wrong and/or how to fix this.

Many thanks

Re: Calculated Dimension help

Gysbert_Wassenaar — Thu, 11 Jul 2013 11:55:47 GMT

That's sounds somewhat familiar, but could be unrelated. Can you post a sample document?

Re: Calculated Dimension help

kaushiknsolanki — Thu, 11 Jul 2013 11:56:17 GMT

Hi,

Make sure that for those figures which are showing in percentages, not having the metrics_Number_or_percent = 'PERCENT' value.

Regards,

Kaushik Solanki

Re: Calculated Dimension help

rathnam_qv — Thu, 11 Jul 2013 12:16:52 GMT

Hi,

try this one....

=If(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target,'#,##0')),

metrics_Number_or_percent)

Re: Calculated Dimension help

jarrad_murray — Thu, 11 Jul 2013 13:12:13 GMT

Many thanks for your reply,

Please find attached an example file of what I am trying to achieve.

Re: Calculated Dimension help

Gysbert_Wassenaar — Thu, 11 Jul 2013 13:31:48 GMT

Probably a bug. Try as a workaround adding a small fraction:

=if(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target+0.00000000001,'#,##0'))

Re: Calculated Dimension help

jarrad_murray — Thu, 11 Jul 2013 13:34:26 GMT

Hi Gysbert,

That has worked. Many thanks for your help.