topic Re: Idente values per delivery in QlikView

Ident values per delivery

Keyuser — Wed, 25 Nov 2020 16:16:04 GMT

Hy!

I have following table:

delivery	country
123	GB
123	GB
123	GB
123	GB
455	IT
455	IT
455	FR
455	IT
455	FR
1234	DE
1234	DE
1234	DE
1234	DE

Would like to recognize if the delivery only took place in one country:

delivery	delivery in one country?
123	true
455	false
1234	true

Do you have an idea for me?

Thank you!

Re: Idente values per delivery

sergio0592 — Wed, 24 Jul 2019 15:59:42 GMT

Hi,

As expression try with:

if(count(TOTAL <delivery> distinct country)=1,'True','False')

Re: Idente values per delivery

Keyuser — Thu, 25 Jul 2019 07:36:43 GMT

And if I need this in the script?

Re: Idente values per delivery

Keyuser — Fri, 26 Jul 2019 06:38:14 GMT

Any idea?

Need a solution in the script instead in expression 🙂

THANK YOU!

Re: Idente values per delivery

sergio0592 — Fri, 26 Jul 2019 07:24:47 GMT

In script statement, try with :

TABLE: LOAD * INLINE [ id,delivery,country 1,123, GB 2,123, GB 3,123, GB 4,123, GB 5,455, IT 6,455, IT 7,455, FR 8,455, IT 9,455, FR 10,1234, DE 11,1234, DE 12,1234, DE 13,1234, DE ]; TABLE2: load if(count (distinct country)=1,'true','false') as delivery_in_one_country?, delivery resident TABLE group by delivery;