topic Re: chart display into the sheet in QlikView

chart display into the sheet

Anonymous — Thu, 12 Mar 2015 10:15:29 GMT

Hi,

I have 4 objects(charts) into a sheet. I used GetSelectedCount()>0 in chart 2,3 and 4.

All the functions working properly but when all the 4 charts are diplaying if i click on 1 chart then 2nd chart not showing 3,4 are showing.i want to change it if anyone click on 1st then 1st will diplay and if anyone click on 3rd then 1,2,3 will show.

Please let me know the process.

Re: chart display into the sheet

Gysbert_Wassenaar — Thu, 12 Mar 2015 10:57:03 GMT

I don't understand your problem. Can you post a qlikview document that demonstrates it?

Re: chart display into the sheet

Anonymous — Thu, 12 Mar 2015 16:07:25 GMT

I have attached application and screenshot.

Re: chart display into the sheet

rubenmarin — Thu, 12 Mar 2015 16:29:20 GMT

Hi Suman, not sure if you want this, but you can change the conditional show of chart 3 to:

GetSelectedCount(@_Status)>0 and GetSelectedCount(@_OPCO)>0

and chart 4 to:

GetSelectedCount(@_Severity)>0 and GetSelectedCount(@_Status)>0 and GetSelectedCount(@_OPCO)>0

Re: chart display into the sheet

Gysbert_Wassenaar — Thu, 12 Mar 2015 17:12:18 GMT

This may come as a suprise, but the getselectedcount function counts the selected values in a field, not the possible values. If you want GetSelectedCount(@_Status)>0 to be true then you need to select a value in the @_Status field. Selecting values in other fields won't help.

Re: chart display into the sheet

Anonymous — Thu, 12 Mar 2015 18:13:30 GMT

Hi Ruben,

Thanks for your reply.

If you check my application one tabular chart showing into last level.

But somehow it's going back of all the objects.

How can i bring it front?

Re: chart display into the sheet

rubenmarin — Fri, 13 Mar 2015 08:19:19 GMT

Hi Suman, in Design (or layout) tab, you can change the 'layer' to 'Superior' or set a number, also in this table you may change the contional show to:

GetSelectedCount(@_Category)>0 and GetSelectedCount(@_Severity)>0 and GetSelectedCount(@_Status)>0 and GetSelectedCount(@_OPCO)>0