Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

A table visulization related issue?

Hello All,

Please guys look at to this one I have done the whole visulization the issue Im facing here is this table visulization is showing every single update of a device , I jus wanted a single device_id which is latest on com_send_time here we have

24-07-2015 11:54:34 updated .

This is the device which must be there

865733022351852       24-07-2015 11:54:34        updated .

865733022352314       24-07-2015 11:59:18        updated.

so on upto 535 device_id

many devices also give " fail" as response code so if there latest data is failed or" in progress" or "not connected" it should show that.

Capture.PNG

Do help guys final moment of the dashboard

An excel for clear vision

Tags (3)
2 Replies
sunilkumarqv
Valued Contributor II

Re: A table visulization related issue?

try this in you Response Code

Only({<Device ID={"$(=Max(com_send_time))"}>}Response Code)


Or


Text({<Device ID={"$(=Max(com_send_time))"}>}Response Code)

Not applicable

Re: A table visulization related issue?

is it working on ur qvd??? cause its not working on mine showing Invalid dimension.

Community Browser