y axes not showing in percent (using Dual)

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

Many thanks

[tejal92]

hi sunny,

below dual function is working in table but not working in barchart and treemap in qliksense.Please help.

=Dual(Num(Sum(days),'##.##')& chr(10)&' ( ' &Num(Sum({<accomodation={'Guest House'}>} days)/Sum( days),'##.##%')& ' ) '
,Num(Sum({<accomodation={'Guest House'}>} days)/Sum( days) ,'##.##%')
)