Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have 2 variabls(From and To) If I have to use range of values between from and To. How can I use it as an expression?
Please anybody help on this
Thanks
cant this be done by just using From and To variables??
why do we need the field
HOUROFDAY must exist as a field in your data otherwise how will your expressions make any sense!? Your chart shows circles of different sizes for different hours of the day - that must come from somewhere! So all you need to do is find a way of limiting the displayed hours. Native QlikView functionality is to make a selection in this field, which you can do direct from the chart. If you want to use From and To variables then the Set Analysis expressions given above will achieve that.
if u want to use it in Expression, you have to apply some aggregation function which you have to apply on a particular field,
Also without field there will be no significance of using these variables...
Ok i'll be using Houroftheday field, but should i use it in dimension??
We cant use expressions in dimensions right?
Please find the attached file