Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share your qvw file?
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
i tried your expression its not working
Provide a sample please
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?
plz find the attached sample file
plz find the sample file that i attached on top
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?
Try this:
GetSelectedCount(SUPCAT)>0 Or GetSelectedCount(name1)>0