Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find Product with two different dates

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?

5 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

May be

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

With product id has dimension

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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.

Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you attach sample file?

Regards,

Jagan.