topic Re: Counting a distinct with condition straight table columns in QlikView

Counting a distinct with condition straight table columns

Fri, 24 Mar 2017 04:00:09 GMT

Customer_Code Year 2016 accounts year 2017 accounts average purchases/customer code growing/declining account count

i wish to count the column of growing/declining accounts which have only growing and declining based on the averages.

=COUNT(DISTINCT(CUSTOMER_CODE)) gives me the total accounts which doesnt differentiate whether it is growing or declining

i can only get the differentiated number when i search for growing / declining in the table itself.

Thanks in advance

sunny_talwar — Fri, 24 Mar 2017 09:13:54 GMT

Can you share few rows of data and explain what your expected output needs to be?

Fri, 24 Mar 2017 09:17:52 GMT

Can you please explain it in detail. If possible share an example

Mon, 27 Mar 2017 00:26:45 GMT

(Growing/Declining Ac column) =If(Num(Column(6))>num((Column(7))), 'Declining', 'Growing')

sunny_talwar — Mon, 27 Mar 2017 09:22:04 GMT

What is your expression behind Column(6) and Column(7) here? You will need to do something like this

Declining Count

Sum(Aggr(If(ExpressionColumn6 > ExpressionColumn7, 1), CUSTOMER_CODE))

Growing Count

Sum(Aggr(If(ExpressionColumn6 <= ExpressionColumn7, 1), CUSTOMER_CODE))

Tue, 28 Mar 2017 00:25:51 GMT

I've solved it by using =(Column(9)) and total mode changed to sum of rows. Thanks for all the help btw :3