Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue Format Qlik Sense

I have a issue. I have a script format number in measure as:

if( $(reportType) = 1,Num(Sum([SalesInOut.GSV])/1000000, '#,##0.00'), Num(Sum([SalesInOut.Quantity]), '#,##0'))

But it does not work, it format base on Number formating qlik sense

Capture.PNG

8 Replies
Anonymous
Not applicable
Author

Hello!

Have you tried changing the number formatting to Auto? Setting it to auto should follow the number format in your script

Anonymous
Not applicable
Author

I tried and it is not same my format.

Anonymous
Not applicable
Author

can you share your qvf?

Anonymous
Not applicable
Author

I tried using your formula and variable and was able to transform the number format

zero.PNGone.PNG

Anonymous
Not applicable
Author

I have filter, Year. If year = 2004, format is #,##0.00%. If year = 2005, format is #,##0. But it fail.

Anonymous
Not applicable
Author

Here

Anonymous
Not applicable
Author

I tried using this formula:

seems repetitive but it works:

num(if(Year = 2004, (Sum(Measure1)/100), (Sum(Measure1))), if(Year=2004, '#,##0.00%', '#,##0'))

or this one

num(sum(Measure1)/if(Year=2004, 100,1), if(Year=2004, '#,##0.00%', '#,##0'))

I think this formatting is only happening when using KPI object. Because using the charts, it's showing the correct number format even inside the if condition

Anonymous
Not applicable
Author

Thanks @Yddona Lyn Aranzanso