Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Set Analysis

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

5 Replies
Highlighted
MVP
MVP

Re: Set Analysis

Try single quote rather than double quote inside {}

Highlighted

Re: Set Analysis

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

Highlighted
MVP
MVP

Re: Set Analysis

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

Qlik Community Tip: Posting Successful Discussion Threads

QlikCommunity Tip: How to get answers to your post?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
marcus_malinow
Valued Contributor III

Re: Set Analysis

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.

Highlighted
Not applicable

Re: Set Analysis

Hi Jonathan,

What more information do I need to porovide?

Rishi