topic Re: show thing is not working in QlikView

show thing is not working

kunkumnaveen — Thu, 14 Apr 2016 10:08:19 GMT

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

Re: show thing is not working

sunny_talwar — Thu, 14 Apr 2016 10:09:35 GMT

Would you be able to share your qvw file?

Re: show thing is not working

sunny_talwar — Thu, 14 Apr 2016 10:10:37 GMT

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

Re: show thing is not working

kunkumnaveen — Thu, 14 Apr 2016 10:12:09 GMT

i tried your expression its not working

Re: show thing is not working

sujeetsingh — Thu, 14 Apr 2016 10:12:40 GMT

Provide a sample please

Re: show thing is not working

sunny_talwar — Thu, 14 Apr 2016 10:13:57 GMT

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?

Re: show thing is not working

kunkumnaveen — Thu, 14 Apr 2016 10:20:59 GMT

plz find the attached sample file

Re: show thing is not working

kunkumnaveen — Thu, 14 Apr 2016 10:21:26 GMT

plz find the sample file that i attached on top

Re: show thing is not working

sunny_talwar — Thu, 14 Apr 2016 10:24:13 GMT

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?

Re: show thing is not working

tresB — Thu, 14 Apr 2016 10:24:41 GMT

Try this:

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

Re: show thing is not working

kunkumnaveen — Thu, 14 Apr 2016 10:27:03 GMT

was it working for you, i copy paste your expression but it was not working in my app

Re: show thing is not working

sunny_talwar — Thu, 14 Apr 2016 10:28:22 GMT

I don't really know what you are trying to do. Can you open my qvw and check if this is doing what you want it to do?

Re: show thing is not working

isorinrusu — Thu, 14 Apr 2016 10:30:38 GMT

Hi naveer, it seems like your table is stucked behind the bar chart (No. of Audits Per Quarter). Hide that bar chart when the table is shown, and you'll solve the problem.

Check the attached file.

Re: show thing is not working

kunkumnaveen — Thu, 14 Apr 2016 10:31:08 GMT

currently i got personal addition, but what i am looking , if i say in simple i need to display the table when i select any values from pie chart

Re: show thing is not working

sunny_talwar — Thu, 14 Apr 2016 10:32:30 GMT

any value means any single value? or can it be multiple values?

Re: show thing is not working

kunkumnaveen — Thu, 14 Apr 2016 11:23:37 GMT

if u see my pie chart it has values like 51,14,168,so i mean on selecting any one value i should see this table

Re: show thing is not working

sunny_talwar — Thu, 14 Apr 2016 11:27:54 GMT

Seems to be working for me:

1) No selection

2) One selection

3) Multiple selections

So the table shows up only when you select one part of your pie chart.

Once again the Expression used:

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

Re: show thing is not working

kunkumnaveen — Tue, 19 Apr 2016 10:08:06 GMT

Hello sunny,

actually i want to hide this bar chart and show table (which is behind this bar chart) on selecting any value in pie chart,i mean if we select 52 from pie chart then see should able to see all those 52 supplier in the below table

Re: show thing is not working

kunkumnaveen — Tue, 19 Apr 2016 10:08:58 GMT

Any more helps and suggestion plz

Re: show thing is not working

isorinrusu — Tue, 19 Apr 2016 10:16:25 GMT

Did you see my answer?