topic Re: how to write expression in QlikView

how to write expression

kunkumnaveen — Tue, 02 May 2017 07:33:43 GMT

Hello,

i have a field called GROUP, and i want to see whether is there any customer who have bought a product in all the three groups.

=count({<Group={'LIFESPACE','CLUB','FINANCE'}>}Customerid)

but this expression counting all the customer who are in the GROUP irrespective of whether customer bought a product in all the GROUP

how to write a expression which check and count only those customerid who bought a product at least once in all the three diff GROUP

Thanks

Naveen

kunkumnaveen — Tue, 02 May 2017 07:45:09 GMT

how to write a expression which check whether the customer brought a product in all the Groups or not

plzz

kunkumnaveen — Tue, 02 May 2017 08:05:54 GMT

Any Suggestions PLz....

kunkumnaveen — Tue, 02 May 2017 08:14:35 GMT

i am looking expression for below requirement

No. of customers who bought life space product also bought CLUB and Finance products in last one year

prieper — Tue, 02 May 2017 08:28:16 GMT

aircode:

COUNT({$ <Prod = {A, B, C}, MyYear = {2016} >} DISTINCT Prod) = 3

else please supply an example

HTH Peter

Anonymous — Tue, 02 May 2017 08:32:24 GMT

May be this =Count(DISTINCT{<Customerid = p({<Group = {'LIFESPACE'}>})*p({<Group = {'CLUB'}>})*p({<Group = {'FINANCE'}>})>}Customerid)??

Anil_Babu_Samineni — Tue, 02 May 2017 09:17:57 GMT

Can you provide data set and expected result

kunkumnaveen — Tue, 02 May 2017 09:52:49 GMT

Thanks Shiva ,it is working.....bang on