Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to show in a table a list of device serial numbers and the average of some data collected from these devices. In my imported data the serial numbers are repeated since data is collected from the same device at different times during the day. So my question is how do i only show distinct serial numbers and the average pertaining to each in my table. Any help would be appreciated.
Thank you.
Hi Ross
Your list box might get you by on this occasion but its not a good solution
You definitely need a chart object. When you create this it defaults to a bar graph. So you just need to go to Properties, select the General tab, and then select Straight Table in the chart type. (Note you can also select pivot tables which are useful too).
Once you get going, you'll be using chart objects all the time !
What is the measure for which you are going to do the average?
It would be something like battery level or disruptions.
Use DISTINCT key word in the expression some thing like
Ex:-
Count( Distinct [Serial Numbers] )
Or you can try some thing like
Ex:-
Count( Distinct [Your Metrics Name Here])
Create a Straight Table
Dimension
[serial number]
expression
COUNT(Distinct YourMeasureFieldName)
As Ross is new to Qlik, and for clarity:
A table object doesn't allow you to include expressions. So you will need chart object, but you can create it as a straight table and then include expressions as Manish has suggested.
Ok so the straight table is not exactly what i am looking for. I just need the table and not the bar graph that comes with the straight table. But i think i got it figured out using a list box and using the field as my serial number and then using the count command to count the total number of disruptions for each serial number. From a minor inspection it looks as if it is only using distinct serial numbers, i am not positive though.
Hi Ross
Your list box might get you by on this occasion but its not a good solution
You definitely need a chart object. When you create this it defaults to a bar graph. So you just need to go to Properties, select the General tab, and then select Straight Table in the chart type. (Note you can also select pivot tables which are useful too).
Once you get going, you'll be using chart objects all the time !
Okk I see what you mean now Richard. thank you that worked brilliantly.
Curious to know whether my answer was working for you or not ?