topic Re: Re: count with expression in QlikView

count with expression

egoziyan — Mon, 11 Nov 2013 16:14:16 GMT

I uses this function to count all the invoices that have sales amount between 0 and 100

count (distinct{<sales={"<100 >=0"}>}INVOICE_NO)

now I want to increase the sales value by a variable. I've added a variable named V_increase_sales and changed the formula to:

count (distinct(<sales*V_increase_sales={"<100 >=0"}>}INVOICE_NO)

and it's not working.

any help will be appreciated

Re: count with expression

jonasheisterkam — Mon, 11 Nov 2013 16:19:57 GMT

count (distinct{<sales={"<100*V_increase_sales >=0"}>}INVOICE_NO)

Re: count with expression

swuehl — Mon, 11 Nov 2013 16:20:33 GMT

Try

=count (distinct(<sales = {"<100/$(V_increase_sales) >=0"}>}INVOICE_NO)

You can only use pure field names left of the equal sign in a field modifier (hence the name).

Re: count with expression

Anonymous — Mon, 11 Nov 2013 16:21:35 GMT

You can use only fields on the left side of "=", that is it must be "sales=" in any case. You have to change your right side to use variable.

Regards,

Michael

Re: count with expression

egoziyan — Wed, 13 Nov 2013 10:00:23 GMT

Thanks for the help, however after I am adding the variable it is not recognized as one between the quotations and therefore doesn't do the calculation

Re: Re: count with expression

swuehl — Wed, 13 Nov 2013 10:22:31 GMT

Qv might have problems evaluating the calculation in the advanced search.

Try

=count (distinct(<sales = {"<$(=100/ V_increase_sales) >=0"}>}INVOICE_NO)

See attached for a sample.

Re: count with expression

egoziyan — Wed, 13 Nov 2013 10:56:09 GMT

Thanks a lot

working fine