5 Replies Latest reply: Mar 16, 2015 4:29 AM by Umer Ikhlas RSS

    Qlikview- Fast Change- Need to neglect negative values

    barathiraja balashanmugam

      Hi Experts,


      I have a pie chart with pivot table as its fast change type.

      I need to display only the positive values both in the Pie chart as well as pivot table.


      my data appears as folows:


      Subscription TypeSales Amount
      one time39000


      So i need to display only the value of  Subscription Type=One time in my chart neglecting the Subscription Type=subscription.


      My value in % calculation exceeds more than 100% in both charts.

      May be i can use RELATIVE to make it 100% in pie chart but how could i do that in pivot table?


      Thanks in advance!