topic Re: How to use alternate state? in QlikView

How to use alternate state?

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

Hi ,

I have built 10 kpis using text box and treading chart respectively,all the text boxes are having actions to filter out the trending chart.

When i click on text box it should filter only respective trending chart ,but it is filtering all the charts .

How can i achieve this?

Thanks,

Shruthi

Re: How to use alternate state?

Anil_Babu_Samineni — Mon, 20 Mar 2017 09:30:02 GMT

Create one variable and then call simple null like vVar

Then, Go to text box layout tab and enable the condition use this If(vVar=1,1,0) and then go to Trend object then use this If(vVar=1,1,0) or use simple select in field by help of same variable

Re: How to use alternate state?

shruthibk — Mon, 20 Mar 2017 09:42:01 GMT

approach is not about hiding the chart.how can we use alternate state to make selection impact on respective charts?

Re: How to use alternate state?

prathapg1959 — Mon, 20 Mar 2017 09:44:25 GMT

Hi shruti,

First you can create alternate state's in settings-document properties(refer the screenshot)

You can enable STATEA in all objects in first sheet,STATEB in second sheet.

SCREENSHOT2:

SCREENSHOT1:

Re: How to use alternate state?

Anil_Babu_Samineni — Mon, 20 Mar 2017 09:51:29 GMT

May be my fault, Alternate states are there? Can you let me know with example, I meant which text box you click and which charts you don't want to effect / Effectiveness.

Usually, We can follow kind of this? I am sorry, If still not the reach you. You may describe more

Sum({AlterState1<Month, Year>}Sales)

Re: How to use alternate state?

prathapg1959 — Mon, 20 Mar 2017 10:00:45 GMT

Dear Anil,

First you need to create alternate state ID (refer screenshot1 and create ID's first) .It will enable alternate states option in all object's automatically.Refer screenshot 2,It will show all id's which you created in setting.

Use first ID in sheet1 for all objects...second ID in sheet to for all object's.

Refer screenshot 2 for enable alternatestate in object's & chart's.

Re: How to use alternate state?

Anil_Babu_Samineni — Mon, 20 Mar 2017 10:02:55 GMT

I thought she well and known about Alternate states guide. I am thinking future not initial stage.

Re: How to use alternate state?

shruthibk — Mon, 20 Mar 2017 10:16:08 GMT

hi i have all the charts in same sheet,predefined calculations from backend ,each text boxes are calculating based on some flags ,i am passing those flags in text object so that it will filter the charts,i can't use single alternate state ,since i am having many bookmarks,when i am trying to use alternatestate book marks aren't working

Re: How to use alternate state?

shruthibk — Mon, 20 Mar 2017 10:57:01 GMT

Re: How to use alternate state?

prathapg1959 — Mon, 20 Mar 2017 12:02:22 GMT

Hi shruti,

We can able to use alternate state's in same sheet also.Better if you able to share sample qvw or screenshot's..It would help us to understand issue easyly...