3 Replies Latest reply: Dec 3, 2014 5:14 AM by Tresesco B RSS

    Qlikview Chart Manipulation

    Kash Jani

      Hello

       

      I have a chart that shows a number of count (Unique ID) on Y axis by countries on X axis.

       

      I have another dimension along with countries to bucket the numbers i.e. 1, 2 to 4, 5-10 etc to group the numbering.

       

      Is there anyway I can count 1 less when something is selected in the chart? This effectively will count the unique ID one less and then show it in the chart.

       

      For e.g. one country might have 5 counts which will put it under 5-10 bucket but because we want to count one less, it will then put it under 2 to 4.

       

      I can't do this during load as we want to preserve the original count to show in a differernt table

       

      Hope I haven't made it too confusing.

       

      Thanks for your help.