topic Re: Ad-hoc Table with Alternate States in App Development

Ad-hoc Table with Alternate States

Siggi_Swiss — Tue, 06 Feb 2024 14:23:20 GMT

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?

Re: Ad-hoc Table with Alternate States

Anil_Babu_Samineni — Tue, 06 Feb 2024 14:29:00 GMT

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

Re: Ad-hoc Table with Alternate States

Siggi_Swiss — Tue, 06 Feb 2024 14:35:57 GMT

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

Re: Ad-hoc Table with Alternate States

Anil_Babu_Samineni — Tue, 06 Feb 2024 14:40:37 GMT

@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!

Re: Ad-hoc Table with Alternate States

Siggi_Swiss — Tue, 06 Feb 2024 14:45:44 GMT

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.

Re: Ad-hoc Table with Alternate States

Anil_Babu_Samineni — Tue, 06 Feb 2024 14:47:16 GMT

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

Re: Ad-hoc Table with Alternate States

Siggi_Swiss — Tue, 06 Feb 2024 14:56:58 GMT

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.

Re: Ad-hoc Table with Alternate States

Anil_Babu_Samineni — Tue, 06 Feb 2024 15:03:11 GMT

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

Re: Ad-hoc Table with Alternate States

Siggi_Swiss — Tue, 06 Feb 2024 15:16:27 GMT

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

Re: Ad-hoc Table with Alternate States

Anil_Babu_Samineni — Tue, 06 Feb 2024 18:55:55 GMT

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

Re: Ad-hoc Table with Alternate States

Siggi_Swiss — Wed, 07 Feb 2024 07:51:06 GMT

here you go, thx in advance

Re: Ad-hoc Table with Alternate States

vinieme12 — Wed, 07 Feb 2024 10:12:30 GMT

add calculation conditions to check for selections in both states

=if(GetSelectedCount(Dim) or GetSelectedCount(Dim,False(),'AlternateStateNAme') ,1,0)

Re: Ad-hoc Table with Alternate States

Siggi_Swiss — Wed, 07 Feb 2024 10:22:18 GMT

thx for your reply. It doesn't work, also I don't want to select a Alternate State to show the table.

In my eyes its a bug in the Software. I'm on Version May 2023 Patch 3 btw.