Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

eleni_theodorid
Contributor

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

Re: And mode in set analysis

What is the expected output here?

Highlighted
eleni_theodorid
Contributor

Re: And mode in set analysis

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
Honored Contributor

Re: And mode in set analysis

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

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

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

С Уважением,

Андрей

eleni_theodorid
Contributor

Re: And mode in set analysis

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
Contributor III

Re: And mode in set analysis

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

Community Browser