topic Re: Change number format in QlikView

Change number format

Wed, 25 Nov 2020 16:16:04 GMT

I have chart which has by default % format which has to change to number format once I click on button.

Thanks

Re: Change number format

sergio0592 — Sun, 14 May 2017 13:12:02 GMT

You can do like this.

-Create a text box and a variable FL_format. In properties Action/Action/Set variable with =if(FL_format=1,0,1).

-In your expression : =num(sum(Express1)/ sum(total Express1),if((FL_format=1),'# ##0,00%','# ##0,00'))

Is this what you're trying to achieve?

Re: Change number format

Anil_Babu_Samineni — Sun, 14 May 2017 16:18:39 GMT

You may need one variable with Set Value from expression Orient

Re: Change number format

Lech_Miszkiewicz — Mon, 15 May 2017 01:45:02 GMT

All above are correct!

the other option you have is to create one column with % and one column with numeric format and then use variable and button to conditionally hide/show columns

i like this option more then formatting numbers using num function as it slightly changes values behaviour when exporting table to excel

regards

Lech

Re: Change number format

Tue, 16 May 2017 05:59:14 GMT

hi,

I have created drill down group in chart & used Sum(pop)/100 as expression.

When I click on chart for Country or State it should calculated Sum(pop)/100. but when I click on City it should show only Sum(pop). This is the actual problem.

Re: Change number format

Anil_Babu_Samineni — Tue, 16 May 2017 06:05:45 GMT

May be change your expression

If(GetFieldSelections(Country) >0 or GetFieldSelections(State) >0, Sum(pop)/100, Sum(pop))

If(GetFieldSelections(Country) >0 or GetFieldSelections(State) >0, Sum(pop)/100, If(GetFieldSelection(City)>0,Sum(pop)))