Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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

Re: show thing is not working

Would you be able to share your qvw file?

Re: show thing is not working

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
Contributor III

Re: show thing is not working

i tried your expression its not working

sujeetsingh
Honored Contributor III

Re: show thing is not working

Provide a sample please

Re: show thing is not working

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
Contributor III

Re: show thing is not working

plz find the attached sample file

kunkumnaveen
Contributor III

Re: show thing is not working

plz find the sample file that i attached on top

Re: show thing is not working

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?

MVP
MVP

Re: show thing is not working

Try this:

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

Community Browser