Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

show thing is not working

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 ,

ECREEN1.png

even  tried like this

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

20 Replies
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
Specialist
Specialist
Author

i tried your expression its not working

sujeetsingh
Master III
Master III

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
Specialist
Specialist
Author

plz find the attached sample file

kunkumnaveen
Specialist
Specialist
Author

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
MVP
MVP

Try this:

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