9 Replies Latest reply: Aug 5, 2013 7:10 AM by kushal chawda RSS

    how to display a chart based on a selected item in a list object

      I have an excel sheets where I have three columns - say Date, StanC_IPR, Airtel_IPR;

       

      In my Qlikview sheet, I am plotting a graph x-axis ->- Date and in y-axis --> StanC_IPR, Airtel_IPR

       

       

      I am creating another list object that lists two items taken from a different excel sheet. The list contains 2 values - Stanc, Airtel.

       

      by default, right now, my graph shows both StanC_IPR and Airtel_IPR.

       

      I want to control the display based on what is selected in the list. that is, if the user selects, Stanc, the graph should plot - date vs StanC_IPR.

       

       

      if the user selects Airtel, then the graph should plot date vs Airtel_IPR

       

      I am not sure what to write in the 'Condition' in Graph object.

       

      Any help is appreciated.

       

      I understand that if i store values in the excel sheet differently, this thing will be automatically taken care by Qlikview. But unfortunately, i cannot change this.