Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sifatnabil
Specialist
Specialist

Dimension with several conditions

Hi all,

I would like to get the list of customers who fulfill these conditions:

1. Have orders live on screen for at least 6 hours a day with eflag="E" on at least 3 distinct instruments

2. Fulfill the above condition for at least 15 days in a month

I started off with a chart with dimension like this:

=if(EFLAG='E',if(aggr(count(distinct {<EFLAG={'E'}>}INSTRUMENT)>=3,CUSTOMER,DATE) and aggr(sum(OrderExit-OrderEntry)>=0.25,CUSTOMER,DATE),CUSTOMER))

and Expression: Interval(Sum(OrderExit-OrderEntry))

But this doesn't seem to work. Is there a better way to yield all customers who fulfill these conditions?

1 Reply
sunny_talwar

Its a fairly complex requirement, this can be either solved by Stefan without a sample or you would need to provide a sample for others to try it out

Best,

Sunny