topic Re: Find Product with two different dates in QlikView

Find Product with two different dates

Tue, 23 Apr 2013 13:49:59 GMT

I have product sales data with history.A particular product has to be sold on some date ex:04/12/2013 as per March month end data.But as of today data that sale date for product may change to 04/24/2013.I want find number of distinct products with two sale dates (One old sale date ad one new sale date).All the history data and daily data are in same table with flags.I tried lot of expessions to find the number.But no solution so far.Any Suggestions?

Re: Find Product with two different dates

CELAMBARASAN — Tue, 23 Apr 2013 13:55:24 GMT

May be

Count({<ProductID={"=Count(Distinct SaleDate)>=2"}>} ProductID)

With product id has dimension

Re: Find Product with two different dates

jagan — Tue, 23 Apr 2013 14:22:42 GMT

Hi,

Use ProductID as dimension in chart and use the following expression

If(Count(DISTINCT ProductID)>=2, Count(DISTINCT ProductID), Null())

Hope this helps you.

Regards,

Jagan.

Re: Find Product with two different dates

Tue, 23 Apr 2013 16:14:46 GMT

Thanks for the reply.I tried no success.I will simplify my requirement.It may be helpful.I want to find the products which have postponed sale dates as of daily data compared to month end data.Product will have some sale dates as of Month end data but as of daily data those sale dates may postoponed to future date.

Re: Find Product with two different dates

Tue, 23 Apr 2013 16:16:13 GMT

Thanks for the reply.I tried it did not work.

Re: Find Product with two different dates

jagan — Tue, 23 Apr 2013 16:33:51 GMT

Hi,

Can you attach sample file?

Regards,

Jagan.