topic Re: Formatting altered when using a dynamic expression in QlikView

Formatting altered when using a dynamic expression

Wed, 18 May 2016 14:31:08 GMT

I have an app where the user can choose the data shown in a chart / table based on an inline loaded list. I don't seem to be able to get any consistent formatting! As in the attached app, when I choose one of the metrics that are ratios, then all is good. The minute I try to use the formats that are straight summed values I often get exponential notations, or what have you.

Any ideas?

Cheers

Re: Formatting altered when using a dynamic expression

Gysbert_Wassenaar — Wed, 18 May 2016 16:14:05 GMT

Try this expression:

IF (%agg = 'sum'

,num(sum({$< QuoteSummaryKPIType = {'Cover Type'} , QuoteSummaryKPIDetails = > } $(=%metric)),'#,##0')

,num(avg({$< QuoteSummaryKPIType = {'Cover Type'} , QuoteSummaryKPIDetails = > } $(=%metric)) ,'#,##%')

)

Re: Formatting altered when using a dynamic expression

Thu, 19 May 2016 08:31:23 GMT

Excellent! That worked, and I should have worked it out....

However.. I've noticed the issue can be recreated even when the formatting has been fixed, by clicking on the QuoteSummaryKPIDetails column.

I used 'QuoteSummaryKPIDetails = >' in the set analysis, so it doesn't filter the data, but it still affects the formatting, which is quite odd! Any more ideas? Cheers!

Re: Formatting altered when using a dynamic expression

Gysbert_Wassenaar — Thu, 19 May 2016 09:29:25 GMT

Try this:

(only({$< QuoteSummaryKPIType = {'Cover Type'} , QuoteSummaryKPIDetails =    > } %agg) = 'sum'
,num(sum({$< QuoteSummaryKPIType = {'Cover Type'} , QuoteSummaryKPIDetails =    > } $(=%metric)),'#,##0')
,num(avg({$< QuoteSummaryKPIType = {'Cover Type'} , QuoteSummaryKPIDetails =    > } $(=%metric)) ,'#,##0%')
)

Re: Formatting altered when using a dynamic expression

Thu, 19 May 2016 09:37:47 GMT

Fantastic! Cheers.. much appreciated. So you need to put the output from the selection that is used in set analysis too? Good to remember that! Thanks again.