Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
i am trting to get cell value from the stra table.
can you suggest how to get it.
Hi Ashish,
I dont understand what you need, what's a stra table?
May you post an example of Input and Output?
Hi Eduardo
Thanks for the updates, please find attached screenshot for your reference.
I have straight table and I am trying to get the specific cell value from that straight table.
Ashish,
If you want just show this value you can use # KPI on left corner and use the SUM() function
If you want store that you can use the same SUM() function on script.
Thanks , how about if I want 2nd or 3rd value from that column?
you have to precise which value you want to work with:
I mean if you want sum(Sales) for the product = american beef bologna
you have to precise it in your expression (in the KPI)
Sum( {<Product={'American beef Bologna'}>}Sales)
Qlik is case sensitive; so u have to write it as it is !
and try to seach in google for "set expression qlik" , you'll find some good tutorials to guide you through such expressions
You will have to add conditions in Set analysis according to your requirement.
For Set Analysis: Learning Set Analysis from Scratch
Dont understand, you want the Sum of all values or individual values?
Please, post some Output example
Hi Eduardo
I am looking for individual values.