topic Min date per attribute & Total Sum in graph in QlikView

Min date per attribute & Total Sum in graph

Thu, 29 Nov 2012 08:41:49 GMT

Hi all,

Question 1)

Is there and way to use Total Mode Sum as a dimention in a graph.

For example illustrate the sum of these specific values in comparison with all the other values, is it possible in a pie chart??

Question 2)

I have a table like this:

Test date	Sensor Status	Unit Serial
28/11/2007 16:47	Fail	1787
28/11/2007 16:53	Fail	1787
28/11/2007 16:54	Fail	1787
05/12/2007 14:39	Fail	1795
05/12/2007 14:42	Pass	1795

My desired table would look like this

Test date	Sensor Status	Unit Serial
28/11/2007 16:47	Fail	1787
05/12/2007 14:39	Fail	1795

So what i have to do is to select the first date per Unit serial.

Any suggestion ideas are welcome.Thank you in advance.

Re: Min date per attribute & Total Sum in graph

Gysbert_Wassenaar — Thu, 29 Nov 2012 12:45:14 GMT

Use an expression like min({<SensorStatus={'Fail'}>}Testdate)

See attached qvw

Re: Min date per attribute & Total Sum in graph

Thu, 29 Nov 2012 13:08:13 GMT

Thanks for answering Gysbert i will try that now.

What about the frist question is there any solution to that???

Re: Min date per attribute & Total Sum in graph

Thu, 29 Nov 2012 14:02:28 GMT

I want in 2 cases to use the total sum of expresions OutOfBoundValues and FirstTimePass to form pie charts comparion the selected percentage with the total.

In the case of OutOfBoundValues i want to create a pie chart to illustrate that the 48.2 percent out of 100 is out of bounds

In the second case i want to create a pie chart to illustrate that 147 values out of ???(total number of selected values) passed right at first time.

See attached file below

Re: Min date per attribute & Total Sum in graph

Fri, 30 Nov 2012 11:42:55 GMT

Any help around this problem???

Re: Min date per attribute & Total Sum in graph

Gysbert_Wassenaar — Fri, 30 Nov 2012 12:52:16 GMT

The Out of Bounds pie chart:

expression 1: =ceil((count({<SensorValue={'>$(=High)','<$(=Low)'}>} SensorValue)/count({$} Total SensorValue) *100),0.01)

expression 2: =100 - ceil((count({<SensorValue={'>$(=High)','<$(=Low)'}>} SensorValue)/count({$} Total SensorValue) *100),0.01)

The First Time Pass pie chart:

expression 1: count(aggr(min(TestDate),UnitSerial))

expression 2: count(UnitSerial) - count(aggr(min(TestDate),UnitSerial))