Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wromanek
New Contributor II

How to add two values from associated table to table chart.

I have two tables:

Documents:

IDNAME
1Doc1
2Doc2

and Events:

DOC_IDEVENTTIME
1CREATED2018-05-14 10:00:00
1PUBLISHED2018-05-15 13:04:00
2CREATED

2018-02-03 11:45:12

2PUBLISHED2018-03-05 10:26:15

What I would like to achieve is table which looks like this:

IDNAMECREATEDPUBLISHEDDURATION
1Doc12018-05-14 10:00:002018-05-15 13:04:001d 3h 4m
2Doc22018-02-03 11:45:122018-03-05 10:26:1539d 22h 41m 3s

I have no idea how could I achieve it with features available with QlikSense. I was trying to add two columns - created:

=IF(EVENT='CREATED', time)

and published:

=IF(EVENT='PUBLISHED', time)

but then I get results which more less looks like that:

IDNAMECREATEDPUBLISHEDDURATION
1Doc12018-05-14 10:00:00
1Doc12018-03-05 10:26:15
2Doc22018-02-03 11:45:12
2Doc22018-03-05 10:26:15

I would appreciate any hints and suggestions.

1 Solution

Accepted Solutions
jaumecf23
Contributor III

Re: How to add two values from associated table to table chart.

Hi,

Attached you can find a solution.

Thanks,

2 Replies
jaumecf23
Contributor III

Re: How to add two values from associated table to table chart.

Hi,

Attached you can find a solution.

Thanks,

wromanek
New Contributor II

Re: How to add two values from associated table to table chart.

Thank you Jaume, now I see what I was doing wrong

Community Browser