This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
i'm trying making a pie chart with these features:
A measure which must have custom values given from an array(i can't retrieve them from any table) ex. myArray['me','bob','jack']
A dimension which must have an expression as value, related to each of the user inside myArray ex. myExpressionArray['=Sum(MyCandies)','=Sum(BobCandies)','=Sum(JackCandies)']
and display it in a pie chart.
At the moment i've displayed the sum of each user in a KPI but i want to display it also in a chart so i'll be able to see the % of each users (obviously i'll display an amount of money not candies )
May be try this
ValueList('me', 'bob', 'jack')
Pick(Match(ValueList('me', 'bob', 'jack'), 'me', 'bob', 'jack'),
View solution in original post
It works perfectly, thank you very much!!