topic Re: set expression based on calculation in QlikView

set expression based on calculation

James_Brems — Sun, 03 Feb 2019 17:39:51 GMT

Hi everyone,

i would like to have a chart that displays the number of customers by Customer Type that had more than X orders in a certain time period (depending on selections).

But the number of orders has to be calculated by a count of order IDs.

data is structured like this:

Customer_ID, Customer_Type, Order_ID, Product_ID, order_date, ...

the chart should have Customer Type as a dimension,

the logic in the formula should be something like this

= count (disctinct Customer_ID) but only for Customers where count (disctinct Order_ID) > 3

Customer IDs should not be in the chart/Table.

any ideas how to do that?

thanks a lot for your help!

Re: set expression based on calculation

Gysbert_Wassenaar — Sat, 16 Feb 2019 14:53:04 GMT

= count ({<Customer_ID={"=count (distinct Order_ID) > 3"}>}distinct Customer_ID)

Re: set expression based on calculation

James_Brems — Fri, 15 Feb 2019 13:49:33 GMT

thanks for the answer, but that does not work.

what would a function like

"=count (distinct Order_ID) > 3"

actually return?

Re: set expression based on calculation

Gysbert_Wassenaar — Sat, 16 Feb 2019 14:53:53 GMT

0 or -1 depending on if the count of distinct order id's is larger than 3 or not.