topic Re: Compare in QlikView

Compare

Anonymous — Thu, 04 Jan 2018 15:30:39 GMT

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?

Re: Compare

Miguel_Angel_Baeyens — Thu, 04 Jan 2018 15:35:44 GMT

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.

Re: Compare

Anonymous — Thu, 04 Jan 2018 15:40:14 GMT

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,

Re: Compare

Miguel_Angel_Baeyens — Thu, 04 Jan 2018 15:45:06 GMT

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)

Re: Compare

Anonymous — Thu, 04 Jan 2018 16:06:53 GMT

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

But thank you for answering

Re: Compare

Miguel_Angel_Baeyens — Thu, 04 Jan 2018 16:13:45 GMT

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.

Re: Compare

Anonymous — Thu, 04 Jan 2018 16:22:21 GMT

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

I already have several solutions to test.

Thank you very much.

Re: Compare

Anonymous — Fri, 05 Jan 2018 09:19:19 GMT

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.