is it possible to get the value(sales in measure) of the first articel(product in Dimension) into a seperat KPI or textfield, etc.
So u have for example a barchart with the sales of the top 5 countries. And u want to show the value of country Top1 in an extra object.
Thx for ur help in advance
Solved! Go to Solution.
Thx for ur answer Sunny,
i know how to calculate it, that how i got the chart to give me this values. But i want the values directly from the chart so i dont have complications with wrong values. Also I try this because i want to add pics ito the kpi instead of the value to show the product pic for the first, seond highest product and so on!!!
I am not sure what you mean directly from the chart? If you are using the expression (not something which is hard coded) which should give you the same value as your chart, is that not similar to pulling the value from the chart?
Not sure if this function is available in Qlik Sense or not and if it will work here or not, but there is a function called GetObjectField() in QlikView. This might have done what you wanted, but you will have to play around with it to be sure