topic Re: Set Analysis Query.. in QlikView

Set Analysis Query..

MuraliPrasath — Thu, 23 Jul 2015 10:55:23 GMT

Hi,

Can someone help me correct this Set Analysis

Count({$<ShipmentStatus={'READY'}, DATE={$(=Today())'}>}DISTINCT(CarrierID))

My Requirement is Count of Distinct 'CarrierID' based on ShipmentStatus='READY' for only Today.

How to achieve this?

swuehl — Thu, 23 Jul 2015 10:57:18 GMT

maybe there is just a single quote missing in DATE set modifier:

Count({$<ShipmentStatus={'READY'}, DATE={'$(=Today())'}>}DISTINCT(CarrierID))

sunny_talwar — Thu, 23 Jul 2015 10:57:54 GMT

May be this:

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(), 'YourDATEFieldFormat))"}>}DISTINCT(CarrierID))

MuraliPrasath — Thu, 23 Jul 2015 11:39:06 GMT

Still no luck !! My Date fileld name is DATE..

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'DATE'))"}>}DISTINCT(CarrierID))

sunny_talwar — Thu, 23 Jul 2015 12:16:41 GMT

Not DATE here

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'DATE'))"}>}DISTINCT(CarrierID))

but the format, like MM/DD/YYYY or DD/MM/YYYY or DD-MMM-YYYY. Whatever format DATE has, need to go within the single quotes.

HTH

Best,

Sunny

MuraliPrasath — Thu, 23 Jul 2015 12:22:48 GMT

Hi Sunny,

Still no luck!!

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'MM/DD/YYYY'))"}>}DISTINCT(CarrierID))

sunny_talwar — Thu, 23 Jul 2015 12:24:42 GMT

Have you made sure that you have CarrierID for today's date where ShipmentStatus = 'READY'??

avinashelite — Thu, 23 Jul 2015 12:29:31 GMT

have you checked the variable value what your getting ?? and make sure that both the dates have the same format

MuraliPrasath — Fri, 24 Jul 2015 04:43:49 GMT

Hi Sunny,

Finally this is worked. Thank you.

Count({$<ShipmentStatus={'READY'}, DATE={"=date($(vToday))"}>}DISTINCT(CarrierID))