topic Re: RE:Dynamic sheet reflect in QlikView

RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 09:57:55 GMT

Hi all,

i have a dynamic table.

Wih in that i have Dimension as "Project" .so my req is

When i click on any of the projct it will redirect to the specific sheet?

How can i achve this?

Thanks in advance.

Suresh

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 09:58:59 GMT

You should be able to add on select trigger based on selections you make in project field. Have you tried that?

Re: RE:Dynamic sheet reflect

Anonymous — Thu, 25 Feb 2016 10:00:09 GMT

IN THAT SHEET TO GIVE THE CONDITION IN LAY OUT IF(GETSELECTION(FIELDNAME='VAULE'),1,0)

Re: RE:Dynamic sheet reflect

sathishkumar_go — Thu, 25 Feb 2016 10:01:33 GMT

HI,

Please provide ur application sample data (atleast Project field value).

-Sathish

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:02:35 GMT

Try the attached application, but I would think that only one selection in Project will work since you cannot possibly go into two sheets at a single time.

Script to create three projects:

Table:

LOAD * Inline [

Project

];

Adjusted the sheet id for the sheets that I need to open

Finally added Activate Sheet trigger with the following Sheet ID

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:02:55 GMT

hi ,

that table as stright table. in that the dimension as project. wen i select any prjct it will redirect to some specific sheet.

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:04:35 GMT

i need hyperlink for that... not usng trigggers

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:06:16 GMT

HyperLink to go to another sheet in the same qvw?

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:07:12 GMT

yes sunny... exctly...is it psble? for perticular dimension?

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:08:03 GMT

not that one.

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:08:18 GMT

Have you tried the application I have added above?

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:31:54 GMT

yes sunny....if it is in stirht table how come it applicable?

Is ther e any other way?

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:34:44 GMT

Seems to be working with the straight table as well. Try out the attached

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:39:29 GMT

yes sunny i hve tried dat one alry....but if i select any other dimension or expression it is reflecng to other sheet..i dnt want that ....only prjct select it will redirect ?

Is this psble?

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:46:53 GMT

I don't think it should be doing that. Let me test it out.

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:48:04 GMT

Add another column and selection in that isn't taking me to another sheet. Check it out

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:52:56 GMT

ok sunny ...let be a side of it.

And in that one more issue is.... i hve that project in the same sheet as listbox or in bar chart group dimension..

so wen i selecting that listbox value it is also reflecting the other sheet . so i dnt want that?

how can i achve this?

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:55:46 GMT

Introduce alternate state. I have made the straight table in another alternate state. List box won't change sheet, but straight table will.

Re: RE:Dynamic sheet reflect

Chanty4u — Thu, 25 Feb 2016 10:56:19 GMT

chk attached

u can u.stnd my requrmnt.only that refct in stight table only...not in other chart or listbox

Re: RE:Dynamic sheet reflect

sunny_talwar — Thu, 25 Feb 2016 10:58:27 GMT

Check my response where I mentioned adding alternate state, I have provided a sample with it