topic Re: Qliksense Date filter in App Development

Qliksense Date filter

oanalung — Fri, 15 Nov 2024 22:56:06 GMT

Hi,

I have 3 tables that I am loading into Qliksense and create one visualization object for each table. In all 3 tables I have different date columns, but I want to create a date filter in Qliksense so I can see simultaneous on all 3 visualizations data for the same period.

Example: I want to see data for 2022-03-01 and I want all visualizations to contain data for that period, but only use one filter(column).

How can I achieve that?

Re: Qliksense Date filter

danielrozental — Tue, 10 May 2022 23:42:04 GMT

You should rename the 3 date fields as the same field name. If more dimensions are shared you should concatenate the 3 tables.

Something like this

Table:

load date1 as date

from table1;

concatenate(Table)

load date2 as date

from table2;

concatenate(Table)

load date3 as date

from table3;

Re: Qliksense Date filter

vinieme12 — Wed, 11 May 2022 00:30:38 GMT

Refer this blog

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Re: Qliksense Date filter

oanalung — Fri, 13 May 2022 11:03:28 GMT

hi, this doesn't seem to work

Re: Qliksense Date filter

danielrozental — Fri, 13 May 2022 21:01:52 GMT

We would need more information in order to be available to help you. Maybe a sample app will do the trick.

Re: Qliksense Date filter

oanalung — Thu, 19 May 2022 12:28:51 GMT

Hi,

I am renaming all fields with the same but then Synthetic keys are created.

I have the following tables:

Table1:

Load

,Date

,Month//Month is created before from date and it has this format: 2022 03

,Column1

,Column 2

FROM qvd1

Load

,Date

,Month

,ColumnA

,ColumnB

FROM qvd2

Table3:

LOAD

ID_2

,Date

,Month

,ColumnX

,ColumnY

FROM qvd3

In the interface I want to use Date and Month as filters to work across all objects(I have multiple charts and each of them is loaded from another qvd). If I keep this load, synthetic keys are created