topic Re: Using Alternate States in Qlik Sense but not using an extension? in App Development

Using Alternate States in Qlik Sense but not using an extension?

Thu, 14 Jul 2016 16:07:42 GMT

Hi ,

I have tried doing alternate states in qlik sense by not using any extensions but got lost at a moment....

Here is the things I did to make alternate states work. I have an item with its unit prices. The client wants to compare item 1 selected in a table chart to another item 2 selected in a table chart beside it on the same sheet.

So , I have created two other fields renaming item as item_selection_1 and item_selection_2. Also applied set analysis to ignore item_selection_2 in item_selection_1 selections.

I achieved it partly where after selecting one item in item_selection_1, I need to select one item from item_selection_1 and then can select items from item_selection_2.....

Is there anything I should apply more to make it work properly and independent of the selections of each item?

Here I have attached an example .qvf for reference.

Thank you.

Re: Using Alternate States in Qlik Sense but not using an extension?

ersanduran — Thu, 27 Oct 2016 14:49:42 GMT

Hi,

You can only achieve this using data islands and P() function in QlikSense. I updated your application and attached. Basically what you do is, you create 2 new tables not attached to your data model (in your case you have only one table but in case you have a complicated data model, Item_Selection_Table1 and Item_Selection_Table2 tables should not be associated to any other tables).

Then in your Dashboard you should associate your selections to your data model using SET analysis and P() function. In your case you need to create 2 separate cost expression as:

Cost 1: sum({$<Item=P(Item_Selection1)>}UnitPrice)

Cost 2: sum({$<Item=P(Item_Selection2)>}UnitPrice)

Please let me know if this approach solves your issue. The application is in the attachment, if you have any questions, please do not hesitate to ask.

Re: Using Alternate States in Qlik Sense but not using an extension?

shraddha_g — Fri, 28 Oct 2016 04:29:41 GMT

Try this Using Alternate State in QLikSense (without Extensions)

Re: Using Alternate States in Qlik Sense but not using an extension?

Fri, 11 Nov 2016 15:43:48 GMT

Thanks Ersan and Shraddha . It works fine.

Re: Using Alternate States in Qlik Sense but not using an extension?

ersanduran — Sat, 18 Mar 2017 13:32:56 GMT

I am glad it was helpful.

Re: Using Alternate States in Qlik Sense but not using an extension?

Fri, 24 Mar 2017 07:27:23 GMT

Thanks!!
It is helpful and easier than I thought.

Re: Using Alternate States in Qlik Sense but not using an extension?

stevedark — Mon, 15 Oct 2018 08:39:23 GMT

This is now implemented properly in Qlik Sense Cloud, it should be appearing in Enterprise and Desktop soon, I would imagine.

This blog post gives the details: http://bit.ly/2ykGhDg

Steve