Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

2 Replies
sunilkumarqv
Specialist II
Specialist II

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
Author

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