Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

Selection Criteria - Separate for each expression

Hello,

We have a straight table with some expressions.  The expressions are related to a time slot (timeslot 1-8).

We are displaying number of days each vehicle is moving (see image).

Slots.jpg

What we want to have it a table containing ID and the number of days related to each timeslot and then have selection criteria as and/or for each slot.

Expression for Moving Slot 1, Slot2, Slot3.....Slot7

=count({<SlotNumber={'1'},dos_moving={'>0'}>}dos_id_pk)

=count({<SlotNumber={'2'},dos_moving={'>0'}>}dos_id_pk)

We want to have a separate slider bar (8 of them) with min and max for each of the slots and then have an AND / OR condition for each of the slots in the same chart. (please see image).

selectioncriteria.jpg

Is it possible to have AND/OR selection criteria for each expression?

Will appreciate if someone can help us with this.