Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding or Including an Altered State

I'm using two tables. One is a list of orders and one is a list of contacts from customers. These tables are linked by the cust_ID column.

Within the tables there are many fields with information relating to "customer", "order" and "customer contact"

I then want to create two side by side graphs. One that includes any selections made in all of my filters "customer", "order" and "customer contact" and one that excludes all fields relating to "customer contact".

The type of question i will be looking to answer will be "If 1/2 of our customers who contact us about X reason bought their product online, are half of all orders placed online?"

My intention was to place all filters that relate to the customer contacting for assistance in an altered state called "State_Contact" and then include that state in a set analysis expression but all examples I can find will need me to list every field.

Is there a way you can create an expression to count a field and exclude an entire group of fields rather than listing every field in every expression?

0 Replies