Hi Kiran, have you thought about using the Gauge chart object?
This allows you to use only the measure without the dimension.
Also, since you are new to Qlik Sense - did you see these videos:
Let us know how you do.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
You do have to add a dimension but perhaps the following example might help ?
Using a synthetic dimension , the dimension expression is as follows: =valuelist('Sales','Costs')
And the Measure Expression is: if ( valuelist('Sales','Costs') = 'Sales', sum(Sales), sum(Costs))
This will 'manufacture' the bars in the chart and then you conditionally assign a measure expression depending on the value of the manufactured expression.
Would this work ?
Its working absolutely fine, but a small thing, actually in the expressions I want to use measures from master items using some if conditions but I couldn't do it but I have achieved it by rewriting the whole expressions in the if condition.
I thought QS alternative for dynamic variables is measures in master items but I am unable to use them in a if condition, correct me if I am work.
Hi Kiran - the names of Master Items cannot be referenced by other calculations just yet. You can define dynamic variables in the script . Just to make sure you use 'Set' in the script and invoke the variable in the expression using dollar sign expansion $(variablename).
//---> expression is saved as a text string
if ( <condition> , $(variablename) )
//---> the expression is inserted , not the string