Ad-hoc Table with Alternate States

[Siggi_Swiss]

I have issues to create a table in Qlik Sense with calculated conditions and Alternate States.

my steps:

• went to master elements and created two date fields out of my Date field in the data model
• i created a table with simple messures like sum(value) etc. and dimensions with a conditions like "=if(wildmatch(concat(GetFieldSelections(Dim),','),'*1*'),1,0)"
• also i set a condition for the whole table 
• 
• now if i select a Dim the table show my measures and selected dimension - perfect
• for comparison i duplicated the table
• Now if i set the Alternate State, all conditions stop working!
• What can i do? Is this a Bug?

[Anil_Babu_Samineni]

@Siggi_Swiss Make sure you used the alternate state for this field as well "Dim", so that both can talk each other on the same state.

[Siggi_Swiss]

Hey @Anil_Babu_Samineni thanks for your response. Can you provide how i have to change the condition "GetSelectedCount(Dim)>0" to work properly? 

[Anil_Babu_Samineni]

@Siggi_Swiss However you have applied to chart, similar way you can apply for list box/filter pane.

Once done, you can try the response and confirm back!

[Siggi_Swiss]

Hey @Anil_Babu_Samineni , ah you get my question wrong i guess. The problem is not alternate states working or calculation conditions working. The problem is that its not working together.

Like i said, after i set the Alternate State to my table, all my calculated conditions stop working. 

[Anil_Babu_Samineni]

@Siggi_Swiss You can share sample QVF to test what is not working, so we cna guide you.

[Siggi_Swiss]

Hey @Anil_Babu_Samineni appreciate your willing to help! Unfortunately its not possible to share data like a .qvf because of our security guidelines. However its just a simple table with the steps i mentioned above. Basically you could just try to set a condition for a table like i did and try to add a alternate state you created before in master items. If the condition still works after that its on my site, otherwise its on Qlik site i guess.

[Anil_Babu_Samineni]

@Siggi_Swiss Please see here

After I added Alternate state, this is how it is!

Now I have attached the file for you, If you are expecting something please modify with this QVF and send it to us to test.

[Siggi_Swiss]

Thanks for providing the QVF. To reproduce the problem just let Dim1 as your dimension in the table and set Dim2 as Date1 State as well as the table.

Now if you select a value in Dim1 nothing happens

[Anil_Babu_Samineni]

@Siggi_Swiss We always suggest you to reproduce the sample file and ask what you need from then. After i  setup as you suggest it is still selective from Dim1 interacting with Tabular.