topic Re: Range in QlikView

Range

Wed, 28 Mar 2012 07:28:29 GMT

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

Range

Wed, 28 Mar 2012 08:29:56 GMT

Please any body help on this

Range

Jason_Michaelides — Wed, 28 Mar 2012 08:44:24 GMT

Hi - can you be more specific about what you want to do? If you want a listbox of all values between the two variable then you can create a listbox using the expression ValueLoop(vFrom,vTo).

Or you may need to create real data points in the script (unless the variable can change).

Hard to help without detail.

Range

Wed, 28 Mar 2012 09:11:17 GMT

I have a grid chart,

y axis as 0 to 23 and x axis as sun, mon to sat.

If any user enter 10 to 15 in the input box I want 10 to 15 in the chart to be highlighted.

I used the reference lines in the presentation tab, but need to know the function to be used to accept this range 10 to 15.

Thanks

Range

Jason_Michaelides — Wed, 28 Mar 2012 09:14:13 GMT

What version are you using? Can you post your app?

Re: Range

Wed, 28 Mar 2012 09:22:10 GMT

version: 9 and attached is the screen shot. Tried with the valueloop. No Joy:(

Any info please let me know..

Thanks

Re: Range

sivarajs — Wed, 28 Mar 2012 09:29:31 GMT

u can use set analysis for range

try this like....

sum({$<field= {'>=10<=15'}>}field)

Sivaraj S

Re: Range

Jason_Michaelides — Wed, 28 Mar 2012 09:29:48 GMT

Can't you just allow users to select HOUROFDAY? Do you need to use variables vFrom and vTo?

If so, I guess your current expression is something like COUNT(something)

Try COUNT({<HOUROFDAY={">=vFrom<=vTo"}>} something)

Re: Range

Jason_Michaelides — Wed, 28 Mar 2012 09:30:50 GMT

(Would help if you can post your app with some data in it)

Re: Range

Wed, 28 Mar 2012 10:21:48 GMT

HI,

you can use it in set analysis as:

Sum({$<Date={">=$(=Date($(vfrom)))<=$(=Date($(=vto)))"}>}Sales)

This expression sum up the sales where date is between vfron and vto (Two variables selected by user with the hepl of calender)

Hope this help...

Regards

Arun Goel

Re: Range

Wed, 28 Mar 2012 11:09:40 GMT

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

why do we need the field

Re: Range

Jason_Michaelides — Wed, 28 Mar 2012 11:13:30 GMT

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.

Re: Range

Wed, 28 Mar 2012 11:14:09 GMT

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

Re: Range

Thu, 29 Mar 2012 04:35:57 GMT

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

We cant use expressions in dimensions right?

Re: Range

Thu, 29 Mar 2012 05:13:39 GMT

Please find the attached file