topic Re: How to get Delta between two selections in the same field in QlikView

How to get Delta between two selections in the same field

Anonymous — Thu, 21 Dec 2017 14:36:10 GMT

Hi,

I'm quite a beginner with Qlikview and really hope you'll be able to help me

I have a set of data, i.e. sold products for one field, and dates for another one :

Product	Date
P1	2017-12-19
P2	2017-12-19
P3	2017-12-19
P1	2017-12-20
P3	2017-12-20

So, in QV I have to boxes, the first one with the products, the other one with de dates.

My problem:

I want to select two dates and display which product were sold during the first date but not during the second.

With the example table above, the result should be "P2" (sold the 2017-12-19 but not during the 2017-12-20).

Is it possible to achieve this with QV ? And, can somebody can help me with this ?

Thanks a lot by advance!

Nicolas

Re: How to get Delta between two selections in the same field

sunny_talwar — Thu, 21 Dec 2017 18:18:18 GMT

May be like this

=Concat(DISTINCT {<Product = {"=Count(Distinct Date) = 1"}>} Product)

Re: How to get Delta between two selections in the same field

Anonymous — Fri, 22 Dec 2017 09:14:33 GMT

Hi Sunny,

Thanks a lot for your help. It works fine.

But my example was incomplete, sorry.

Actually, It doesn't work with more dates and products.

For example (limited with 3 dates and 4 products, but there can be more), with Table:

LOAD * INLINE [

Product, Date

P1, 2017-12-18

P4, 2017-12-18

P1, 2017-12-19

P2, 2017-12-19

P3, 2017-12-19

P1, 2017-12-20

P3, 2017-12-20

];

If I select the two first dates, I expect to get 'P4' in the text box, but in fact it displays 'P2P3P4' (P2 and P3 being associated to the third date).

Do you think that it's possible to do it with QV ?

Thanks again.

Nicolas

Re: How to get Delta between two selections in the same field

sunny_talwar — Fri, 22 Dec 2017 16:33:28 GMT

I think your data is like this

Table:

LOAD * INLINE [

Product, Date

P1, 2017-12-18

P4, 2017-12-18

P1, 2017-12-19

P2, 2017-12-19

P3, 2017-12-19

P2, 2017-12-20

P3, 2017-12-20

];

Try this

=Concat(DISTINCT {<Product = {"=Count(Distinct {<Date>} Date) = 1"}>} Product)