Set Analysis

[subbareddykm]

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 ?

[#2]

Hi

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

[subbareddykm]

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

[Anil_Babu_Samineni]

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

[#5]

Hi subbareddy

I have attached QVW for your reference

[subbareddykm]

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.

[subbareddykm]

Can anyone help me on this?

[Anil_Babu_Samineni]

May be this

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

OR

=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

[subbareddykm]

Hi Not working,

U can use any one app of this thread?

App is attached while creating this thread.

[krishna20]

Hi Subbaredy the below logic works for your senario

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

OR

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

And then Calculated dimension should be this

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