topic Re: Set Analysis with p() and inequality in QlikView

Set Analysis with p() and inequality

Fri, 11 May 2012 20:50:27 GMT

I have the following script as an expression but I need it to be greater than or equal to the CalendarDateKey. The normal set analysis for >= is not working with a p() function. Any help would be great.

Count({$<QvsI = {"I"}, CalendarDateKey1=p(CalendarDateKey)>}QvsI)

Set Analysis with p() and inequality

Fri, 11 May 2012 22:16:46 GMT

this should work

Count({$<QvsI = {'I'}, CalendarDateKey1={">=CalendarDateKey"}>}QvsI)

Re: Set Analysis with p() and inequality

Mon, 14 May 2012 18:46:53 GMT

When I use the given script the output is all zeros.

I have attached a test .qvd. I am having the same issue with the count for quotes too so I just attached that since I already had a test file made using that formula. As you can see, when I put the p() function in with the = sign, it gives me fairly accurate output for the quotes but I need to add the inequality >= to the function. When I use the format above (in column Quotes Test) it gives output of all zeros.

It might be my formatting on the dates but I'm still not sure how to fix this.

Thanks

Re: Set Analysis with p() and inequality

Tue, 15 May 2012 19:11:12 GMT

Does anyone have a suggestion on how to correct this date comparison issue?

Thanks

Re: Set Analysis with p() and inequality

goldnejea8 — Tue, 15 May 2012 20:57:26 GMT

Count({$<QvsI = {'I'}, CalendarDateKey1>={'CalendarDateKey'}>}QvsI)

Set Analysis with p() and inequality

Tue, 15 May 2012 21:11:33 GMT

This script gets a syntax error.

I had tried the script given by Juan, which is what I think you were getting at, but this isn't working. As you can see in my test .qvw above this isn't working in the field Quote Test because it makes all values zero.

Thanks