5 Replies Latest reply: Feb 24, 2016 9:40 AM by omar bensalem RSS

    set analysis in qlik sense

    omar bensalem

      Hi guys,

       

      I'm really new in qlik sense and I'm trying to use the jauge for the first time;

       

      when I try to copy the expression I have in the qlikview, it don't work:

       

      here what I tried so far, what should I change?

       

      'evolution='& num((Sum({$<MyDay={"$(=$(vDayMax))" },min15={"$(=max(min15))"}>}Montant_Vente)-Sum({$<MyDay={"$(=$(vDayMin))" },min15={"$(=max(min15))"}>}Montant_Vente))/(Sum({$<MyDay={"$(=$(vDayMax))" },min15={"$(=max(min15))"}>}Montant_Vente)+Sum({$<MyDay={"$(=$(vDayMin))" },min15={"$(=max(min15))"}>}Montant_Vente))*100 ,'#,##') &'%'

       

      and

       

      'evolution : '& num((Sum({$<MyDay={$(vDayMax) },min15={"$(=max(min15))"}>}Montant_Vente)-Sum({$<MyDay={$(vDayMin) },min15={"$(=max(min15))"}>}Montant_Vente))/(Sum({$<MyDay={$((vDayMax) },min15={"$(=max(min15))"}>}Montant_Vente)+Sum({$<MyDay={$((vDayMin) },min15={"$(=max(min15))"}>}Montant_Vente))*100 ,'#,##') &'%'

       

      I'm really in a BIG hurry; thank you all

        • Re: set analysis in qlik sense
          Sunny Talwar

          When you say it doesn't work, does it mean it gives you an error? shows incorrect result? shows 0? shows '-'? Please elaborate?

          • Re: set analysis in qlik sense
            Sangram Reddy

            Hi Omar,

             

            Looks like you are concatenating and sending in a string through your expression. Is it possible to share a sample?

             

            Thanks,

            Sangram.

            • Re: set analysis in qlik sense
              bruno bertels

              Bonjour

               

              Pas sur que les expressions dans une jauge sous Qlik sense acceptent cette syntaxe : 'texte=' & mesure &'%'

               

              Je te conseille de tester ta mesure seule dans un objet KPI ou Texte ou Jauge

              et de tester indépendamment chaque partie de ta formule,  puisque tu as des variables,  pour vérifier ce que cela renvoie dans un KPI ou objet texte.

               

              Bruno

              • Re: set analysis in qlik sense
                omar bensalem

                I found the error; Let me explain,

                I'm using a time calendar and I want to only show the days I have;

                for example, in my QVD, I only have 03/01 and 10/01; so I only want to show the days 03 and 10.

                 

                To do so, here is how I proceeded:

                let vMinDate=peek('AddedDate',0, 'Calendar');

                let vMaxDate=peek('AddedDate',-2, 'Calendar');

                 

                 

                let vDayMax=day('$(vMaxDate)');

                let vDayMin=day('$(vMinDate)');

                 

                 

                NoConcatenate

                Calendar2:

                LOAD *

                Resident Calendar

                where AddedDate= date('$(vMinDate)','DD/MM/YYYY') or AddedDate= date('$(vMaxDate)','DD/MM/YYYY') ;

                 

                 

                DROP Table Calendar;

                 

                 

                 

                 

                DROP TABLE CalendarTemp;

                 

                 

                 

                Now, in Qlikvieew, if I want to use these variables, I need to add another $ sign:

                like this for example:

                 

                =num((Sum({$<MyDay={"$(=$(vDayMax))" },min15={"$(=max(min15))"}>}Montant_Vente)),'#,##')& ' TND'

                 

                QlikSense won't recognize this syntax; you have to write it like this: MyDay={$(vDayMax)}

                 

                But even when I write it like so, Sense doesn't recognize it.

                 

                 

                What I did is:

                 

                - commenting the :

                let vDayMax=day('$(vMaxDate)');

                let vDayMin=day('$(vMinDate)');


                in the script, and instead creating 2 variables with the same expression.

                 

                Now when I use my new variables with sense like this MyDay={$(vDayMax)}, it all go all right !



                • Re: set analysis in qlik sense
                  Andy Weir

                  remove the

                   

                  'evolution='& from the start of your expression and the &'%' from the end of it.  Its expecting a number not a string.

                   

                  Looks like you are returning Evolution=98% for example

                  when what you want to return is just the 98.

                   

                  Sense handles the formatting itself and you don't need to name it.  you use the label filed for that.

                   

                   

                  Regards

                   

                   

                  Andy