show thing is not working

[kunkumnaveen]

Hi,

I am trying to show a table only if when either of these fields get selected

                                             1.SUPCAT,

                                             2.A add dimension field(=Aggr(FirstSortedValue({<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>}SUPCAT, -DATE_OF_REVIEW), name1))  which is name1

so in table under layout conditions i wrote this

                                        GetSelectedCount(SUPCAT)=1 or GetSelectedCount(name1)=1

so when i select supcat filed i am able to show the table

but when i select a pie chart which is having a add dimension as  name1 filed then i am not able to show the table ,

even  tried like this

GetSelectedCount(SUPCAT)=1 or GetSelectedCount(Aggr(FirstSortedValue({<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>}SUPCAT, -DATE_OF_REVIEW), name1))=1

[sunny_talwar]

Would you be able to share your qvw file?

[sunny_talwar]

Just for trying, can you try this:

GetSelectedCount(SUPCAT)=1 or Count(DISTINCT Aggr(FirstSortedValue({<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>}SUPCAT, -DATE_OF_REVIEW), name1)) = 1

[kunkumnaveen]

i tried your expression its not working

[sujeetsingh]

Provide a sample please

[sunny_talwar]

Can you try this:

GetSelectedCount(SUPCAT)=1 or Count( DISTINCT {<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>} Aggr(FirstSortedValue({<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>}SUPCAT, -DATE_OF_REVIEW), name1)) = 1

If this still doesn't work, would you be able to add a sample?

[kunkumnaveen]

plz find the attached sample file

[kunkumnaveen]

plz find the sample file that i attached on top

[sunny_talwar]

This seems to be working, isn't it?

GetSelectedCount(SUPCAT)=1 or Count(Distinct Aggr(FirstSortedValue({<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>}SUPCAT, -DATE_OF_REVIEW), name1)) = 1

Can you check now?

[tresesco]

Try this:

GetSelectedCount(SUPCAT)>0 Or GetSelectedCount(name1)>0