3 Replies Latest reply: Aug 17, 2017 5:02 AM by Anil Babu RSS

    QlikView Filter

    Tsiry Elhy

      Hello community,

       

      I have a problem with QlikView.

       

      I have a table, with

       

      Dimension: =ValueList('A','B','C','D')

       

      And 4 expressions :

       

      Janv : if(ValueList('A','B','C','D')='A',Sum({<Month={'janv.'}>}Nb_files))

       

      Fev : if(ValueList('A','B','C','D')='A',Sum({<Month={'févr.'}>}Nb_files))

       

      Mars : if(ValueList('A','B','C','D')='A',Sum({<Month={'mars'}>}Nb_files))

       

      Avr : if(ValueList('A','B','C','D')='A',Sum({<Month={'avr.'}>}Nb_files))

       

      test.JPG


      What I would like to do is display only in the table the data of the months less than or equal to the selected month.

       

      For example : if I select the month of Mars, in the table the data of Janv, Fev, Mars AND empty on Avr.

      Attached my qlikview file.

       

      Thank you in advance for your help.


      (I'm sorry for my English, I don’t speak English very well)




       

        • Re: QlikView Filter
          Anil Babu

          Then, Why do you need B,C,D in your list?

            • Re: QlikView Filter
              Tsiry Elhy

              I have several axpression, in B : =Avg(Nb_files) , in C Min(Nb_files), in D Max(Nb_files)

                • Re: QlikView Filter
                  Anil Babu

                  May be explain little more your business, We can figure it out more easy

                   

                  Janv : if(ValueList('A','B','C','D')='A',Sum({<Month={'janv.'}>}Nb_files))

                  Fev : if(ValueList('A','B','C','D')='A',Sum({<Month={'févr.'}>}Nb_files))

                  Mars : if(ValueList('A','B','C','D')='A',Sum({<Month={'mars'}>}Nb_files))

                  Avr : if(ValueList('A','B','C','D')='A',Sum({<Month={'avr.'}>}Nb_files))


                  When you use Static it won't work rather try this?

                  if(ValueList('A','B','C','D')='A',Sum({<Month={'$('<=' & =Max(Month))'}>}Nb_files))