Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
eleni_theodorid
Partner - Creator
Partner - Creator

And mode in set analysis

Hi all,

I have a case and I need your help!

I want and mode in set analysis too but I don't want user make any selection.

I need to count all customer's that own both car and boat and the boat is A.

Please advice.

Thanks in advance,

Eleni !

5 Replies
sunny_talwar

What is the expected output here?

eleni_theodorid
Partner - Creator
Partner - Creator
Author

Hi Sunny,

There are a lot of things!

A table with all customers owns both car and boat and the boat is A, per Sales Channel.

See the refreshed app.

Regards,

Eleni

ahaahaaha
Partner - Master
Partner - Master

Привет Элени,

Concat (Aggr (только ({<Customer = { "= Aggr (Count (Заказчик), Заказчик) = 2"}, {Пункт = 'A'}>} Заказчик), Заказчик), ',')

Смотри прикрепленный файл.

С Уважением,

Андрей

eleni_theodorid
Partner - Creator
Partner - Creator
Author

Hi Andrey,

Thanks a lot for your reply and sample.

Due to my bad Russian I would prefer to communicate in English if it's ok for you as well!

Your sample is close enough but I need the customer count, not the actual values, I have try to convert your expression but there is always an error....

Regards,

Eleni

CarlosAMonroy
Creator III
Creator III

Hi Eleni,

Maybe You can try the following:

count(Distinct {<HaveCarFlag ={'1'}, HaveBoatFlag={'1'}, SalesChannel = {"=count(Distinct CustomerID)"}>} CustomerID)

and for the filters you do not want to work with the user selections, just add them into the set analysis like this:

Filter1=, Filter2= and so on.

Hope that helps,

Carlos M