2 Replies Latest reply: May 16, 2018 2:35 AM by Wojciech Romanek RSS

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

    Wojciech Romanek

      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.