Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

Try

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist
Specialist

Hello,

please check with this

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

Regards,

anant

Highlighted
Not applicable

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

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