Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi People,
I would like to do conditional formatting of number for scatter plot and KPI. If it fits the condition match(Fin, 'IQ')<>0, then I would like the number to show as percentage like 95.6%, otherwise, just show as normal number like 95.6. Somehow, the formatting with num function does not work properly after I add If condition. It works without if condition.
Please see my example code below:
If(
match(Fin, 'IQ')<>0,
num(Avg(
{
State4< FYear={'$(vStartYear)'}, nValue-={0}>
}
nValue)/100, '#,#%'),
Avg(
{
State4< FYear={'$(vStartYear)'}, nValue-={0}>
}
nValue)
)
Interestingly, the same formula above works in table element.
Anyone can help? Thanks!
try below
If(
Fin= 'IQ' and Fin <>0,
num(Avg(
{
State4< FYear={'$(vStartYear)'}, nValue-={0}>
}
nValue)/100, '#,#%'),
Avg(
{
State4< FYear={'$(vStartYear)'}, nValue-={0}>
}
nValue)
)
IF( FIN='IQ' ,num(Avg(
{
State4< FYear={'$(vStartYear)'}, nValue-={0}>
}
nValue)/100, '#,#%'),
Avg(
{
State4< FYear={'$(vStartYear)'}, nValue-={0}>
}
nValue))
is it possible to share sample QVF
We are facing the same problem. Any ideas or solution will be appreciated
What is the output of '$(vStartYear)' in each element?
It is working for me
Could you please share the .qvf?
What version are you suing?
Hi, I was using Qlik Sense Nov 2018 Version. The number format does not work in graph. Which version are you using?