5 Replies Latest reply: Oct 20, 2012 5:53 AM by Anil Kumar RSS

    experssion

    Srinivasa D

      Hi

       

      can any one pls exlpain me

      below experssion

       

       

       

      Sum({$<Year={$(=Max(Year)),
      $(=Max(Year)-1)}>}  Sales / $(vCurrency))

       

      thanks

        • Re: experssion
          mayilvahanan ramasamy

          Hi

           

          Its sum the sales for maximum year ans maximum year -1 and divide by currency variable value

           

          for example.

          Year

          2009

          2010

          2011

          2012

           

          its sum the  2012 and 2011 year sales  and divide by variablevalue

            • Re: experssion

              hi, Set Analysis used in this expression. Explore about Set Analysis in community. There is a lot of information in community.

               

              Regards

               

              -Anil

                • Re: experssion
                  Srinivasa D

                  Hi Thanks for your reply.

                   

                   

                  my data as below

                   

                  Medical 30-Sep-12 50
                  Medical 30-Sep-12 50
                    sum=100


                  Dental 31-Sep-2012 100
                  Dental 31-Sep-2012 100
                    
                    sum=200

                   

                  Now i need to calcaulte 200-100=100 how i can achive this in qlikview by useing set analysis

                   

                  thanks

                    • Re: experssion

                      Hi Srinivasa1,

                       

                      First you have to understand basics of QlikView, like data management, basics of Set Analysis and how QlikView work.

                       

                      QlikView load data distinctly, when the data source have two identical row then QlikView load single row only due its default behavior, rather than both row, if you need both row then you have use no distinct or other mechanism in load.

                       

                      When you filtered data with the selection of a dimension and you want to calculate something beyond this selected dimension value then you need Set Analysis.

                       

                      For example there is dimension in your data set say Year, and you chose Year : 2009 and you want to calculate sales value of year 2008 or 2009 then you need to use of Set Analysis.

                       

                      In your case, suppose you selected Dental then you have to wright.

                       

                      Sum(Value) – sum( { $ < Nature={‘Medical’} > } Value)

                       

                      Hope it will help.

                       

                      Regards

                       

                      Anil