Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
I wloud like to display these values in percentage..is it possible ? :
Go to Solution.
sum(YourMeasure) / sum(total YourMeasure)
Omar - is there an option to select relative in Qlik Sense like we have in Qlik View?
no we don't have @sunny
My first try was this :
Zied, if u want to keep also the numbers;
do as follow:
YourDimension&': '& aggr(sum(YourMeasure),YourDimension)
with that, u'll have the percentage on the bar, and the number besides each dimension
what are u searching for then?
U'll be marking ur own answer as correct as always? hahahaha
Thanks Omar just we need to add num to have percentage :
num (sum(YourMeasure) / sum(total YourMeasure),'# #0,00%')
I changed the set analysis and kept the simple dimension
oh hell no !! u can always use formats qlik offers if u use this as a measure !
no need to use the num ()
ps: I won't repeat this to u ever again