topic Re: Newbie Set Analysis question in QlikView

Newbie Set Analysis question

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

Hello there folks .. an absolute newbie to my QLIK Developer license here .. I apologise if this is too simple or has been asked a thousand times before.

I wanna COUNT Distinct of FieldA for all records associated with EXCEPT that the user has selected in FieldB.

What should that Expression be please?

Many thanks

Re: Newbie Set Analysis question

Anil_Babu_Samineni — Mon, 14 Aug 2017 13:16:47 GMT

Perhaps this?

Count({<FieldA = E({<FieldB = {$(=Concat(Chr(39) & GetFieldSelections(FieldB) & Chr(39) ))}>}FieldB) >} DISTINCT FieldA)

Re: Newbie Set Analysis question

Anil_Babu_Samineni — Mon, 14 Aug 2017 13:18:32 GMT

Or this

Count({<FieldA = E({<FieldB = {$(=Concat(Chr(39) & GetFieldSelections(FieldB) & Chr(39) , ','))}>}FieldB) >} DISTINCT FieldA)

Re: Newbie Set Analysis question

sunny_talwar — Mon, 14 Aug 2017 13:30:50 GMT

Or just this

Count({<FieldB = e(FieldB)>}FieldA)

Re: Newbie Set Analysis question

skellington — Tue, 15 Aug 2017 00:11:12 GMT

MAN!! That's fantastic. Works like a charm - thanks SO much!! Rgds Jack

Re: Newbie Set Analysis question

oknotsen — Tue, 15 Aug 2017 06:55:52 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .