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
      subscription-2563

       

      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!