4 Replies Latest reply: Jan 26, 2016 6:19 AM by ramasudhakar kotha RSS

    Qlikview setanalysis without using aggregation function

      Hi,

      I dont want to consider month selection while using chart and does not require to use aggregation at caluclation.

      I have written following setanalysis caluclation

       

      =If(Aggr='R',only({<Month=>}($(vMed))),only({<Month=>}($(vMed))))

      This is working fine and all results are coming correct.

      however i have written an experssion at dimension level to show back ground colour and text colour in bold format, this is not working after using Month in setanalysis.

      Can you guys throw some insight on this ?

       

      Regards,

        • Re: Qlikview setanalysis without using aggregation function
          Gysbert Wassenaar

          =If(Aggr='R',

               only({<Month=>}($(vMed))),

               only({<Month=>}($(vMed)))

          )

          Both branches of your if statement are the same. And both branches have a closing parenthesis without a matching opening one. Your expression cannot work (unless your variable vMed contains an opening parenthesis).

           

          I don't understand your problem. Perhaps you can post a small qlikview document that illustrates the problem.

            • Re: Qlikview setanalysis without using aggregation function

              Hi Gysbert,

               

              Thanks for your reply.

              Sorry did not mention formula correctly

              Now the correct one is

               

              =If(Aggr='R',

                   only({<Month=>}($(vMed))),

                   only({<Month=>}($(vMedia)))

              )

              and this is working.

              The only reason is we are getting data from excel and it has already calulcations done and iam showing that data in chart without any aggregation using setanalysis.

              The chart shouldnot change when specific month selection is done,It need to display the chart for whole year.

              With this formulae its working fine however the bold format for dimension and back ground is not working due to "only" in caluclation level.

              At the dimension level i have wrriten following for back ground colour

              If(match(format,'H','B'),rgb(210,210,210)) and

              text format

              If(match(format,'H','B'),'<B>')

              The earlier formulae where its working for back ground and text format is

              =IF(AGGR='R',($(vMedida)),($(vMedida_SinRollup))) however its showing chart for specific month selection and we want to exclude month and show whole year without effecting month selection


              If(Aggr='R',

                   only({<Month=>}($(vMed))),

                   only({<Month=>}($(vMedia)))

              )



              Regards,

              Ram