topic Re: Set Analysis in QlikView

Set Analysis

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

Hi All ,

I need one logic to fileter the how many ID s are created Sub ID and Rel Id in differenet Table using Set Analysis,

Can anyone help on this ?

Re: Set Analysis

Mon, 23 Jan 2017 05:27:08 GMT

subbareddy can you elaborate what you exactly want i can't undersatnd

Re: Set Analysis

subbareddykm — Mon, 23 Jan 2017 05:38:13 GMT

If u open my application Every ID does not have SUb ID and Rel ID.

I wan To Count How many ID does not have Sub Id's and same like the Rel ID

Re: Set Analysis

Anil_Babu_Samineni — Mon, 23 Jan 2017 06:00:03 GMT

From this you want to show 2 as output / What?

Try below in Text box and let us know

=Count({<[Rel ID] = {*},[Sub ID] = {*}>}ID) //This gives, Where two values has for ID

and

=Count({<[Rel ID] -= {'-'},[Sub ID] -= {'-'}>}ID) // This Gives, Count only ID's where not the values for [Sub ID] & [Rel ID]

OR Try this

=Count({$-<[Sub ID]={'*'}>} ID) // $ and - is there

Re: Set Analysis

Mon, 23 Jan 2017 06:24:59 GMT

Hi subbareddy

I have attached QVW for your reference

Re: Set Analysis

subbareddykm — Tue, 24 Jan 2017 08:49:56 GMT

In this , i have one more scenario ,I want to count ID's Where Sub ID should not be nul and Rel ID should be Null In set Analysis,

also suggest me how to create calculation dimension on the same.

Re: Set Analysis

subbareddykm — Tue, 24 Jan 2017 09:40:40 GMT

Can anyone help me on this?

Re: Set Analysis

Anil_Babu_Samineni — Tue, 24 Jan 2017 09:57:24 GMT

May be this

=Count({<[Rel ID] = {'*'},[Sub ID] -= {'-'}>}ID)

=Count({<[Rel ID] = {'-'},[Sub ID] -= {'-'}>}ID)

And then Calculated dimension should be this

Aggr(Count({<[Rel ID] = {'-'},[Sub ID] -= {'-'}>}ID), [Rel ID],[Sub ID])

Assuming is not good accuracy. If Not, The better offer if you share the application

- ANIL

Re: Set Analysis

subbareddykm — Tue, 24 Jan 2017 10:21:20 GMT

Hi Not working,

U can use any one app of this thread?

App is attached while creating this thread.

Re: Set Analysis

krishna20 — Tue, 24 Jan 2017 10:24:29 GMT

Hi Subbaredy the below logic works for your senario

Count({<[Rel ID] = {'*'},[Sub ID] -= {'-'}>}ID)

=Count({<[Rel ID] = {'-'},[Sub ID] -= {'-'}>}ID)

And then Calculated dimension should be this

Aggr(Count({<[Rel ID] = {'-'},[Sub ID] -= {'-'}>}ID), [Rel ID],[Sub ID])

Re: Set Analysis

subbareddykm — Tue, 24 Jan 2017 10:50:02 GMT

No its not working,

You can check that logic my application.

Let me know whether it is working or not ?