Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Multiple Selection/Condition Set Analysis

Hi.

My problem is with Setting two conditions in Set Analysis.

Case Scenario: Calculate Tickets updated today.

Objects : GroupID , Updated Date

Requirement : Show total count for Tickets updated today and assigned to Group 15.

What is working is to show total amt of tickets updated for today with following code;

count({1<ASSIGNEDDATE_NUM={ '$(vToday)'} >} TicketID)

What is not working is when i try to assign it to Group = 15.

count({<GroupID ={'15'} ,{1<ASSIGNEDDATE_NUM={ '$(vToday)'} >} TicketID)

Expert help would be appreciated in this matter.

Best,

Bradley

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Multiple Selection/Condition Set Analysis

Try

count({1<GroupID ={15}, ASSIGNEDDATE_NUM={'$(vToday)'} >} TicketID)


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Multiple Selection/Condition Set Analysis

Try

count({1<GroupID ={15}, ASSIGNEDDATE_NUM={'$(vToday)'} >} TicketID)


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist
Specialist

Re: Multiple Selection/Condition Set Analysis

Hello,

please check with this

=count({<ASSIGNEDDATE_NUM={ '$(vToday)'}, GroupID ={'15'}>} TicketID)

Regards,

anant

Highlighted
Not applicable

Re: Multiple Selection/Condition Set Analysis

Hi Gysbert!

this Solution works great with a pre-prepared Excel sheet.

However when i try to run it in my application based on live data it seems to have no effect.

do you think that the field types could play a role in this?

Highlighted
MVP & Luminary
MVP & Luminary

Re: Multiple Selection/Condition Set Analysis

Yes, it's probably a problem with dates. Check that assigneddate_num is actually a numeric date. You may have to use the date# function.


talk is cheap, supply exceeds demand