Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Greetings for the day.
I have one bar chart which represents the amount based on type and i have two text boxes to show data in dollars and percentage.
If i click on dollar button then values on bar should show like $ 100..If i click on Percentage button then it should show values on bars with percentage like 20 %..
For this i have created one expression and devided by variable values(based on selection either % or $).
But the corresponding $ and % values are not displaying in bar chart.
Could you please anybody take a look into this. I have attached sample QVW also.
Thanks,
Chiru
Try attached:
Try as attached
Best,
Sunny
Hi Sunny,
Thanks for your Help.
All is fine but when we switch to % then axis is showing as 0.0 to 1.2 instead of showing 0 to 100.
Is there option to change this
Thanks,
Chiru
Try attached:
Hi,
one more way, without using the if condition in expression,
like Num(Sum({<Type={'Target'}>}Amount)/$(vDlr),$(vDec))
PFA for reference..
HI Sunny,
Thanks! This is exactly what i expected.
Thanks,
Chiru
Awesome
I am glad I was able to help.
Please mark the correct answer if you have got the answer you were expecting.
Best,
Sunny