topic Multi value Slider variables in Set Analysis in QlikView

Multi value Slider variables in Set Analysis

IAMDV — Fri, 06 May 2011 16:14:03 GMT

Dear All,

I am using a Slider (object) with Multi value with TimeStamp. I had attached the screenshot for your reference. And I am using the following expression to calculate the value for Current Hour.

COUNT({$<TimeStampValue = {$(=($(vMaxCurrentTime)))} , Q_No ={'Q1'} >} Resp_ID)

However, I wanted to look at multiple continious hours, like 6 AM to 10 AM. I am saving the values in variables... like Minimum & Maximum value to calculate the time. But I am not sure on how to integrate the range in the above expression. Something like this... (Highlighted in red color for readability).

COUNT({$<TimeStampValue >= {$(=($(vMINCurrentTime)))} AND TimeStampValue <= {$(=($(vMaxCurrentTime)))} , Q_No ={'Q1'} >} Resp_ID)

I hope this makes sense...

Many thanks in anticipation!

Cheers - DV

Multi value Slider variables in Set Analysis

erichshiino — Fri, 06 May 2011 16:20:11 GMT

HI,

You should include both conditions inside {}

Try this:

COUNT({$<TimeStampValue = {'>$(=($(vMINCurrentTime))) <=$(=($(vMaxCurrentTime))) '} , Q_No ={'Q1'} >} Resp_ID)

(please double check the number of parentesis in my expression)

Regards,

Erich

Multi value Slider variables in Set Analysis

Oleg_Troyansky — Fri, 06 May 2011 16:24:20 GMT

Not quite... The syntax of Set Analysis Modifier is :

Field = {Values}, where the "equal sign" is not to define that the field is equal (or greater then) the Values, but rather to determine what to do with this selection and with the User Selections. "=" means "replace user selections with those values", other operators like "-=" and "+=" may mean subtracting or appending selections.

So, for your purpose you need to define a range in the form of a search condition (double quotes signify search):

COUNT({$<TimeStampValue = {$(">=$(vMINCurrentTime)<= $(vMaxCurrentTime)"} , Q_No ={'Q1'} >} Resp_ID)

You also need to watch for a possible mismatch of the date/time format. Variables can only hold either formatted values or numeric values of the timestamps, but not both. The format of the variable needs to be exactly the same as the format of your field TimeStampValue.

Best,

Re: Multi value Slider variables in Set Analysis

IAMDV — Fri, 06 May 2011 16:32:28 GMT

Oleg - Thank you very much for explanation. I will try the same and I just wanted to check if there is any range function with gets the possible values between min & max values... instead of using the <MaxValue and >MinValue.

Thank you again for your time.

Cheers - DV

Re: Multi value Slider variables in Set Analysis

IAMDV — Fri, 06 May 2011 16:39:13 GMT

Thank you Erich & Oleg

Multi value Slider variables in Set Analysis

Oleg_Troyansky — Fri, 06 May 2011 17:01:11 GMT

No, not that I can think of... I always use the >Min<Max approach...