Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello!
Have you tried changing the number formatting to Auto? Setting it to auto should follow the number format in your script
I tried and it is not same my format.
can you share your qvf?
I tried using your formula and variable and was able to transform the number format
I have filter, Year. If year = 2004, format is #,##0.00%. If year = 2005, format is #,##0. But it fail.
Here
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
Thanks @Yddona Lyn Aranzanso