Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I have y axes showing as percent
If I try to change format setting from the Number tab the dual function will not work anymore,
so guess need a solution within the Dual function,
=Dual(
If(MyDate=Max(total MyDate), Name, ''),
Sum ([Grade])/Max(Total Aggr(Sum([Grade]), [Name]))
)
Thanks
Raphael
I have further simplified your chart...
1) No dual function needed for 1st expression
2) you can set formatting for 1st expression through numbers tab
3) name is driven by second expression
Many thanks
hi sunny,
below dual function is working in table but not working in barchart and treemap in qliksense.Please help.