topic Set Analysis in QlikView

Set Analysis

Tue, 14 Jul 2015 12:56:08 GMT

Hi All,

Below mentioned set analysis function is not working.

count({<CurrentStatusPT={'Processed'}, TotalElapsedTimeBucketPT={"[00:30 hrs]","[01:00 hrs]","[01:30 hrs]","[02:00 hrs]">}BatchID)

Please suggest corrections.

TIA

Regards,

rishikesh

MK_QSL — Tue, 14 Jul 2015 12:57:18 GMT

Try single quote rather than double quote inside {}

alexandros17 — Tue, 14 Jul 2015 12:57:35 GMT

I think this format 00:30 hrs is not correct, verify in a text box if the used format is valid

jonathandienst — Tue, 14 Jul 2015 12:58:22 GMT

You will need to provide more information in order to get useful suggestions.

marcus_malinow — Tue, 14 Jul 2015 13:05:33 GMT

count({$<CurrentStatusPT={'Processed'}, TotalElapsedTimeBucketPT={'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]','[02:00 hrs]'}>} BatchID)

A couple of minor corrections, including properly closing off your second set.

Wed, 15 Jul 2015 10:09:27 GMT

Hi Jonathan,

What more information do I need to porovide?

Rishi