Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Range

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

14 Replies
Not applicable
Author

cant this be done by just using From and To variables??

why do we need the field

Jason_Michaelides
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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...

Not applicable
Author

Ok i'll be using Houroftheday field, but should i use it in dimension??

We cant use expressions in dimensions right?

Not applicable
Author

Please find the attached file