Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Gysbert_Wassenaar

Try

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

Try

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


talk is cheap, supply exceeds demand

View solution in original post

anantmaxx
Specialist
Specialist

Hello,

please check with this

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

Regards,

anant

Not applicable
Author

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?

Gysbert_Wassenaar

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