topic Re: Data format in QlikView

Data format

Anonymous — Tue, 13 May 2014 07:54:56 GMT

I have a staright table with measures as sales and quantity and have two buttons for selection(sales and quantity).

On clicking sales button it will display the sales values and on clicking the quantity button it will dispaly quantity related values.

My requirement is when i will click on sales button it should show me the vlaues in price format and the quantity values in number format.

Can anyone please help me on this ?

Re: Data format

alexandros17 — Tue, 13 May 2014 07:58:23 GMT

when you display the quantity values e.g. sum(qtyValues) write:

Num(sum(qtyValues), '#.##0')

and with prices:

Num(Sum(price), '€ #.##0,00;-€ #.##0,00')

Re: Data format

anbu1984 — Tue, 13 May 2014 08:44:12 GMT

In Chart Properties (Number --> Expression), Select number format settings

Re: Data format

SunilChauhan — Tue, 13 May 2014 08:48:05 GMT

In expression itself you can apply formats

using NUM function

like Num(FieldName,'$#') for ineteger whith $

like Num(FieldName,'$#.00') for decimal whith $

like Num(FieldName,'$#,##.00') for decimal whith $

for thousand seperator and decimal and $

you can also take money format using number(properties-> number-> money) see and apply using text box

hope this helps

Re: Data format

Anonymous — Tue, 13 May 2014 08:53:36 GMT

have changed the format to money and number..but its not working.

Re: Data format

SunilChauhan — Tue, 13 May 2014 08:54:49 GMT

can you please attached the sample

Re: Data format

Anonymous — Tue, 13 May 2014 09:41:47 GMT

Try like this

In the Script create a variable

Let vSum=Num(sum(qtyValues), '#.##0');

Let vPrice=Num(Sum(price), '€ #.##0,00;-€ #.##0,00');

Re: Data format

Anonymous — Tue, 13 May 2014 09:50:47 GMT

Re: Data format

SunilChauhan — Tue, 13 May 2014 09:57:30 GMT

can you give example which format you want your numbers/amount

Re: Data format

Anonymous — Tue, 13 May 2014 10:06:16 GMT

For value i need in money format and for volume its like number format.

Re: Data format

SunilChauhan — Tue, 13 May 2014 10:17:45 GMT

hope you using some variable

so you can use like below

if( var=Value NUm(value,#.##0,00 kr;-#.##0,00 kr),NUm(Volume,'#,##'))

hope this helps

Re: Data format

Tue, 13 May 2014 10:43:13 GMT

Hi,

You can create two expression and hide/show expression using condition hide and give different format to each expression in properties of chart -> Number tab.

Hope it works.

Shameem.

Re: Data format

Anonymous — Tue, 13 May 2014 11:15:27 GMT

It worked fine now.

Thanks all for your help

Re: Data format

SunilChauhan — Tue, 13 May 2014 11:19:08 GMT

Please marked it as correct for future refrence