topic Change the Number format for one value from the Expression in QlikView

Change the Number format for one value from the Expression

Fri, 22 Aug 2014 17:48:21 GMT

Hi,

My input table structures looks like something that is mentioned below:

Week	Sales
Week1	10
Week2	20
Week3	30
Week4	40

I want to add a text box in the dashboard, that would only show the sum(sales) for Week4. And also the format for the expression should be in '%' value.

I tried applying the following expression in the text box, however it did not work !

Formula: =sum({$<Week={'Week4', '#,##0%'}>}[Sales])

Any thoughts on this ?

~Shalaka

Re: Change the Number format for one value from the Expression

jaimeaguilar — Fri, 22 Aug 2014 17:50:30 GMT

Hi,

try like this:

num(sum({$<Week={'Week4'}>} [Sales]), '#,##0%')

The % format has to be set by a function (num in this case),

regards

Re: Change the Number format for one value from the Expression

MarcoWedel — Fri, 22 Aug 2014 21:37:01 GMT

Hi,

another solution:

=Num(Sum(If(Week='Week4', Sales)), '#,##0%')

hope this helps

regards

Marco