topic Show one value once in Table Box in QlikView

Show one value once in Table Box

Wed, 15 Dec 2010 16:39:08 GMT

Hello to all of you,

I am pretty new to QV, I am connected to a SQL database and selected all the tables. But when I want to create a Table box I get the same record more then once. Because it has multiple timestamps. How do I make sure it appears once. Is it possible to do this in the script?

And also how do I make a Gauge (StopLight) of the created Table Box?

Greetz!

Show one value once in Table Box

boorgura — Wed, 15 Dec 2010 17:04:36 GMT

Am not sure what your requirement is.

But, if all the data is same except the timestamp, you can just use the floor function to convert the time stamp to date and then do a load distinct.

And you might as well think the option of Straight/Pivot table as opposed to using a table box.

you can as well change the same chart type to a gauge chart. (Setting the style to traffic lights)