Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
When you say it doesn't work, does it mean it gives you an error? shows incorrect result? shows 0? shows '-'? Please elaborate?
Hi Omar,
Looks like you are concatenating and sending in a string through your expression. Is it possible to share a sample?
Thanks,
Sangram.
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
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 !
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