How to make 2 bar charts with 2 different details from same tables without duplicate tables

[Anonymous]

Hi,

I wondering how can i make Dashboard sheet with 2 bar charts from same tables and show 2 different data details from them.

For Example:

The tables are -

CUSTOMERS;

id;

name;

address;

phone;

DATA FINANCIAL REPORTS;

id;

data_report 1;

data_report 2;

data_report 3;

data_report 4;

data_report 5;

data_report 6;

now i want to show a compare screen, there will be show 2 same bar charts but first chart will show details for company "ABC" and the second chart will show details on company "XYZ".

all this process have to be without duplicate the tables and make CUSTOMERS2; DATA FINANCIAL REPORTS2; with the same data into.

screen shout is attached for clearly understand the request

Thanks

Best regards

Itai

[swuehl]

Have a look at the concept of alternate states / set analysis.

If you are unfamiliar with both, start with QV11 for developers book.

[Anonymous · Accepted solution]

Thanks,

There's  a very useful extension for this issue: Comparative Analysis - Alternate States with Qlik Sense

It helped me a lot.