topic Re: Set analysis in QlikView

Set analysis

kmswetha — Thu, 11 Jun 2015 11:09:59 GMT

Hi ,

I have to write the below condition in set analysis.

Today()-Run_date<=30.

How do I write this in Set analysis.

Regards,

Swetha

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:11:13 GMT

May be this:

{<Run_date = {"=Today() - Run_date <= 30"}>}

Re: Set analysis

kmswetha — Thu, 11 Jun 2015 11:21:08 GMT

This is working, But I Have to also add <=30 and >60.

Also can you explain me how this works?

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:24:03 GMT

How can the above be true? something can be less than and equal 30, but cannot be simultaneously greater than 60? Do you mean <=30 or >60??

Re: Set analysis

kmswetha — Thu, 11 Jun 2015 11:25:05 GMT

<30 and >=60

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:25:16 GMT

If I am right, try this:

{<Run_date = {"=(Today() - Run_date) <= 30 or (Today() - Run_date) > 60"}>}

Re: Set analysis

kmswetha — Thu, 11 Jun 2015 11:25:52 GMT

Sorry >30 and <=60.This is correct one,

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:25:54 GMT

Are you trying to get between 30 to 60?

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:27:10 GMT

Try this:

{<Run_date = {"=(Today() - Run_date) > 30 and (Today() - Run_date) <= 60"}>}

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:30:55 GMT

If this for some reason doesn't work, you can also try this:

{<Run_date = {"=(Today() - Run_date) > 30"}*{"=(Today() - Run_date) <= 60"}>}

Re: Set analysis

kmswetha — Thu, 11 Jun 2015 11:31:47 GMT

This is not working for me

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:33:45 GMT

And what about this one?

{<Run_date = {"=(Today() - Run_date) > 30"}*{"=(Today() - Run_date) <= 60"}>}

Re: Set analysis

kmswetha — Thu, 11 Jun 2015 11:37:34 GMT

Even this is not working.Syntax is correct but it is not considering the set.

Re: Set analysis

kmswetha — Thu, 11 Jun 2015 11:42:19 GMT

Hi SunIndia,

Latest is working.

But am curious how would Run_date hold >30 condition?

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 11:48:17 GMT

Not sure I understand what you are curious about??? Run_date hold > 30 condition???

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 12:13:24 GMT

I am not sure I understand what you wanted to know? Let me know if you would need any clarification and I will be more than happy to help.

Best,

Sunny

Re: Set analysis

kmswetha — Thu, 11 Jun 2015 16:04:48 GMT

Hi,

In the below expression

how is it working when Run_date is equated to Today() - Run_date <= 30, though we are actually looking days between today and rundate?

Re: Set analysis

sunny_talwar — Thu, 11 Jun 2015 17:32:49 GMT

We are not telling it to show us the Run_date = Today() - Run_date <= 30, instead we are telling the expression to pick only those rows where Today() - Run_date <= 30. You might be able to use another field in place of Run_date (preferably unique field) to test the condition as well.

I hope this make sense?

Best,

Sunny

Re: Set analysis

kmswetha — Fri, 12 Jun 2015 09:07:29 GMT

Thx Sunny.Now I get the point.

Re: Set analysis

sunny_talwar — Fri, 12 Jun 2015 10:10:17 GMT

No problem at all

Glad I was able to help.