topic How to make these two sheets to be operated independently in one qlikview document in QlikView

How to make these two sheets to be operated independently in one qlikview document

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear Team,

In on Qlikview document I have created two sheets.

In each sheet, one table was placed.

First sheet contains the drop down selection for CLASS.

Second sheet also contains the drop down selection for CLASS.

Loaded data pertains to CLASS from 1 to 10.

Requirement is :

User selects CLASS 2 in first sheet.

As well User selects CLASS 5 in second sheet.

Even after these two selections, in each sheet respective class data to be displayed. Selection in one sheet should not affect the data on selection in another sheet.

How to make these two sheets to be operated independently in one qlikview document.

Re: How to make these two sheets to be operated independently in one qlikview document

xavieravinson — Thu, 29 Dec 2016 10:13:59 GMT

Hi Rafee

Please try the alternate states in qlikview.

With Regards

Xavier

Re: How to make these two sheets to be operated independently in one qlikview document

Thu, 29 Dec 2016 10:28:40 GMT

Hi Rafee

First crate alternate state in document properties=>General=>

next go to the sheet properties in general =>select alternate state

Re: How to make these two sheets to be operated independently in one qlikview document

raajaswin — Thu, 29 Dec 2016 10:31:25 GMT

Qlik View not affected chart

same one

Re: How to make these two sheets to be operated independently in one qlikview document

Thu, 29 Dec 2016 10:34:49 GMT

Re: How to Save a sheet in qlikview with current selections to other sheet in same app.

engishfaque

Create Alternate State and use in your chart, which you want to use for comparison

3.1. Main Menu > Settings > Document Properties... (Ctrl + Alt + D) > General Tab >

Click on Alternate States... > Add... > New State Name "Type your State Name like

Alternate_State_Example" > OK > OK > Apply > OK.

3.2. Chart Properties > General Tab > Alternate State > "Select your State Alternate_State_Example >

Apply > OK.

Re: How to make these two sheets to be operated independently in one qlikview document

sankartalluru — Thu, 29 Dec 2016 10:37:35 GMT

Hi,

Please share the sample app with data.

Re: How to make these two sheets to be operated independently in one qlikview document

Thu, 29 Dec 2016 10:55:55 GMT

Hi Sankar ,

verify the Aswin Raj reply in the following link

Qlik View not affected chart

Re: How to make these two sheets to be operated independently in one qlikview document

Anonymous — Thu, 29 Dec 2016 11:15:29 GMT

Thank you very much

Re: How to make these two sheets to be operated independently in one qlikview document

Anonymous — Thu, 29 Dec 2016 11:15:42 GMT

Thank you very much

Re: How to make these two sheets to be operated independently in one qlikview document

Anonymous — Thu, 29 Dec 2016 11:15:59 GMT

Thank you very much

Re: How to make these two sheets to be operated independently in one qlikview document

Anonymous — Thu, 29 Dec 2016 11:16:19 GMT

Thank you very much

Re: How to make these two sheets to be operated independently in one qlikview document

Thu, 29 Dec 2016 11:19:54 GMT

Hi Rafee,

Please mark the reply in(Action button) above as helpful/correct answer to close the thread

Re: How to make these two sheets to be operated independently in one qlikview document

Anonymous — Thu, 29 Dec 2016 11:19:59 GMT

Thank you very much

Re: How to make these two sheets to be operated independently in one qlikview document

susovan — Thu, 29 Dec 2016 11:24:20 GMT

You can also try this following process,

Please find the attachment for requisite output.

Process 1:

Process 2:

Process 3:

Process 4:

Process 5:

Re: How to make these two sheets to be operated independently in one qlikview document

Anonymous — Thu, 05 Jan 2017 04:25:28 GMT

Thanks guys..