Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ruthubarra
New Contributor II

Same information different charts

Good day

I have a question, i am building my application using several Excel spreadsheet that contain exactly the same fields. What i am trying to achieve is the following, the chart on the left must shown total information of all entities and the chart on the right should have only the information of one entitiy.

Obviuosly as you can see both have the same info everytime i select something.

Please help

Thanks in advance

Charts.jpg

1 Reply
MVP
MVP

Re: Same information different charts

If I understood correctly, create a field when loading your Excel files that identify your source:

LOAD

    'A' as SOURCE,

     FieldA,

     FieldB,

     ...

FROM YourExcelFile_A.xls;

LOAD

     'B' as SOURCE,

     FieldA,

     FieldB,

     ...

FROM YourExcelFile_B.xls;

...

[Just a demo, you don't need to explicite repeat the LOAD statements, if you can make the Source definition dynamic, e.g. by parsing FileName() ]

Then use a filter in your second chart to limit the records to one source (e.g. B), like

Sum({<SOURCE= {'B'}>} FieldA)

Sum({<SOURCE= {'B'}>} FieldB)

Community Browser