topic Re: Count Changing Status in QlikView

Count Changing Status

ch_riadh — Mon, 13 Feb 2017 09:42:49 GMT

Sales_Table:

SalesID,

Date,

Status (Sold, invoiced, delivered).

I want to know how many SalesID changed from sold to delivered in a specific period.

Thanks

luke1986 — Mon, 13 Feb 2017 10:29:40 GMT

Hello Riadh,

Use this Expression as a Formula in a Chart

=count({<SalesID=p({<Status = {'Sold'}>}),Status = {"delivered"}>}distinct SalesID)

That should do the job.

Lukas

ch_riadh — Mon, 13 Feb 2017 10:38:43 GMT

it works fine, but i want to use the date,

For exemple i need to display the change in oct, then decembre.
How can define the Date in that expression.