Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

OmarBenSalem
Esteemed Contributor

set analysis in qlik sense

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

5 Replies

Re: set analysis in qlik sense

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

reddys310
Honored Contributor II

Re: set analysis in qlik sense

Hi Omar,

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

Thanks,

Sangram.

brunobertels
Valued Contributor

Re: set analysis in qlik sense

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

OmarBenSalem
Esteemed Contributor

Re: set analysis in qlik sense

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 !



ogster1974
Honored Contributor II

Re: set analysis in qlik sense

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

Community Browser