11 Replies Latest reply: Jan 5, 2018 9:50 AM by Raju Kannuri RSS

    Dynamic Format in Bar chart

    Raju Kannuri

      Hi Community,

       

      I have developed one chart based variable selection it will change the SalesAmount and Sales%.

      Expression 1:

      Sum(Sales)

       

      Expression 2:

      Num(Sum(Sales)/Sum(Total Sales), '##,#0.00%')

      Note: Num format not working, like showing 0.63. I have to convert into 63%


      these expression's changing based on toggle button. (Amount and Percentage)


      In Qlikview NUM format works fine, but qlik sense not working.


      I have read this document... https://community.qlik.com/thread/161478

      but not working..


      Please anyone can help me....


      Thanks in Advance....