Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have created inline ,
TrendView:
Load * Inline [
%View, Format
Number , 1
Percent, 2
];
And say i have expression like
if (format = 1 ,Sum(Aggr(Bounces,VisitFull)) ,Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%')
)
and created a List box for View Number , format
if i select Number is shows the value and if i select it showing value but not percentage calculated and without % sign..
if am i putting an expression Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%') without if condition
it working fine...
can any one help me to sort out this
format and Format are two different fields. Make sure to use the correct case sensitive field name.
And make sure not to overrule the expression format on the Numbers tab. Leave the setting for the expression to Expression Default.
hi Gysbert ,
Sry , i am writing
if (Format = 1 ,Sum(Aggr(Bounces,VisitFull)) ,Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%')
)
Only ... but its not working
Post a small qlik sense document that demonstrates the problem.
i am putting qvf kindly check
I'm afraid Qlik Sense doesn't honor the % format in the num function yet in bar charts. I can't get it to work either.
Without if Condition i am able to do % Format..
Kindly give me solution for this
Hi
Can u help me on this .. how to resolve this
See attached qvf. That's the best I can do at this time.