topic Re: Date from different tables in QlikView

Date from different tables

Tue, 20 Jun 2017 14:19:43 GMT

Hello, i am facing a problem when trying to analyze data from different tables in the same date.
For example, I wish to show on a KPI the total AMOUNT OF SALES on a given month.year selected from a filter, in another KPI i would like to show the total EXPENSES in this same month.year selected.
However, these data are in two sepearate tables, that are not linked trough any pirmary key, so, in order for me to show these values i need to put 2 filters in my app and the user will need to select the month.year in twice.

Wouldn´t be possible for me to select from only one filters the month.year i wish ?

Re: Date from different tables

ahaahaaha — Tue, 20 Jun 2017 14:49:51 GMT

Hi,

It would be nice to see a small sample of the original data and the required result.

Re: Date from different tables

Tue, 20 Jun 2017 15:06:52 GMT

Hello Andrey,

The Data is organized like this:
TABLE SALES

SALES_CODE | SALES_DATE | SALES_VALUE
1 |16 JUN 2017 | $ 40,00

2 |14 JUN 2017 | $ 35,00

3 |13 JUN 2017 | $ 20,00

TABLE EXPENSES

EXPENSES_CODE | EXPENSES_DATE | EXPENSES_VALUE
1 |11 JUN 2017 | $ 20,00

2 |17 JUN 2017 | $ 15,00

3 |10 JUN 2017 | $ 10,00

What i expect of result is having one filter (Year.Month)

|Date.YearMonth|

|May.2017 |
|June.2017 |

Where i select June.2017 and i can show both TOTAL SALES = $ 95,00 and TOTAL EXPENSES = $45,00

So far, i can only do that if i create 2 different filters one with SALES_DATE.YearMonth and another one with EXPENSES_DATE.YearMonth, and i woul like to find a way to do it with only one filter in the app.