topic Compound Set Analysis AND Comparison in QlikView

Compound Set Analysis AND Comparison

jonathandienst — Mon, 02 Aug 2010 16:36:58 GMT

I am trying to convert this expression (from a table containing StartDate and DealCode) to set analysis and I have hit a snag

This is the IF expression which works correctly

Count(If((StartDate >= '2010/07/01') AND (StartDate <= '2010/07/31'), DealCode))

After a some attempts, I got this:

Count({<StartDate={'>=2010/07/01','<=2010/07/31'}>} DealCode)

But, the problem is that it seems to be combining the comparisons by ORing them, which means that the entire date range is being included. I need them to be ANDed, to produce only dates within the range.

This happens whether the date comparisons are separated, or combined like '>=2010/07/01,<=2010/07/31', or even if I put 2 StartDate={} expressions in the set.

What am I missing here?

Jonathan

Compound Set Analysis AND Comparison

mike_garcia — Mon, 02 Aug 2010 16:43:04 GMT

Hello,

Use this:

Count({<StartDate= {">=2010/07/01<=2010/07/31"}>} DealCode)

Double quotes indicate search string. You may need to adjust the date format to match the data exactly as it is stored. Sometimes I use the number representation to avoid confusion.

Regards,

Mike.

Re. :Compound Set Analysis AND Comparison

martin59 — Mon, 02 Aug 2010 16:43:24 GMT

Hi Jonathan,

You have to try this :

Count({<StartDate={">=2010/07/01 <=2010/07/31"}>} DealCode)

Compound Set Analysis AND Comparison

markmccoid — Mon, 02 Aug 2010 16:51:52 GMT

You pretty much have it just change it to the below:

Count({<StartDate={'>=2010/07/01<=2010/07/31'}>} DealCode)

Hope this helps.

Compound Set Analysis AND Comparison

jonathandienst — Mon, 02 Aug 2010 16:52:15 GMT

Duh!

Thanks Martin and Mike - I forgot that " means search string. I tried virtually every combination I could think of except that one.

BTW - it works correctly with or without the spaces.

Jonathan