topic Re: Multiple Selection/Condition Set Analysis in QlikView

Multiple Selection/Condition Set Analysis

Wed, 20 Mar 2013 11:10:49 GMT

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

Gysbert_Wassenaar — Wed, 20 Mar 2013 11:12:59 GMT

Try

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

Anonymous — Wed, 20 Mar 2013 11:15:46 GMT

Hello,

please check with this

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

Regards,

anant

Wed, 20 Mar 2013 11:53:37 GMT

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 — Thu, 21 Mar 2013 11:22:45 GMT

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.