Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shruthibk
Creator
Creator

How to use alternate state?

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

12 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
shruthibk
Creator
Creator
Author

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

prathapg1959
Contributor III
Contributor III

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:

ALTERNATE STATE2.png

SCREENSHOT1:

ALTERNATE STATE.png

Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
prathapg1959
Contributor III
Contributor III

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.

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
shruthibk
Creator
Creator
Author

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

shruthibk
Creator
Creator
Author

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

prathapg1959
Contributor III
Contributor III

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...