2 Replies Latest reply: Jun 8, 2011 5:59 AM by Neetu Singh RSS

    How to use where in Qlik view chart type

      Hello Experts,

       

      I am new to Qlikview and trying to find my way to a problem.

      Here is the problem

       

      Following is the set of data

       

      XYZFGHMV
      ABCDECMO100.00
      LMNOCMO200.00
      bbbbbbbbbbTFG300.00
      bvnghGBH400.00
      jghtyRFT500.00

       

      I want to bring all the records back which have column FGH as 'CMO' in straight table type. Following is the resultant dataset

       

      XYZFGHMV
      ABCDECMO100.00
      LMNOCMO200.00


      Please let me know if this possible. If yes then how.

      Thank you very much for your help

       

      Cheers,

      Sumit

        • How to use where in Qlik view chart type

          HI,

           

          I`m assuming that XYZ and FGH are dimensions and MV Numeric part of your table.

           

          Take XYZ and FGH in straight table as dimension and add below code as expression.

           

          =sum({<FGH = {"CMO"}>} MV)

           

          this may help you.

           

          - Sridhar

          • How to use where in Qlik view chart type
            Neetu Singh

            Hi,

             

             

            you can also use "if" statement as in your expression :

             

            sum(if(FGH = 'CMO',MV)).

             

            and if you want in dimension, then click on add calculated dimension and write : = if(FGH = 'CMO',FGH)

             

            By using this dimension in straight table it only shows CMO as mention below. when you use in dimension then your expression will be sum(MV).

             

            XYZFGHMV
            ABCDECMO100.00
            LMNOCMO

             

            Hope it will help you

             

             

             

            Regards

            Neetu Singh