Compare

[Anonymous]

Hello,

I have a database containing all the tickets and the magazines.

I want to create two filters to choose two stores and compare two charts.

Have you ever had this problem?

I intend to load the table twice but I think this is not optimal.

Do you have other ideas?

[Miguel_Angel_Baeyens]

You can use set analysis, assuming there is a field named Store, you could use two expressions in your chart like

Count({< Store = {'Store1'} >} Tickets)

Count({< Store = {'Store2'} >} Tickets)

You could also use alternate states and set analysis as in the What is New In QlikView 11 demo application, in the Product Grouping tab. You can install these apps along with your QlikView Desktop.

[Anonymous]

Thank you for your reply.

However, I would like the user to choose his own store, which is why I do not think that Set Analysis can solve the problem.

Regards,

[Miguel_Angel_Baeyens]

Which is the case for the alternate states, along with set analysis.

I strongly recommend to take a look at that application (there will be many others for sure, but that one does exactly what you are looking for)

[Anonymous]

This report is fine for a model but I use qliksense.

But thank you for answering

[Miguel_Angel_Baeyens]

Then I'd suggest you post in the Qlik Sense area.

Anyway, you can still use Qlik Sense APIs to create alternate states, or use the two table approach and use set analysis with P() element function for it.

Or use an extension, you have several in Branch.

[Anonymous]

I was looking for ideas that's why I posted a little partour 🙂

I already have several solutions to test.

Thank you very much.

[Anonymous · Accepted solution]

Hello,

I found that yesterday, and that's exactly what I want to do.

Using Alternate State in QLikSense (without Extensions)

Thanks for the answers.