Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count number of value present in a column?

Hello,

I have a file with different column : Timestamp field, number1, number2, number3, number4.  I am loading this file and create a Cross table

Cross table :

03-09-2012 00:04:15 6360 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:09:18 6093 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:14:22 6329 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:19:26 5951 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:24:30 6280 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:29:34 6079 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:34:40 6548 qmem://<bundled>/BuiltIn/led_o.png warning
03-09-2012 00:39:43 6189 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:44:47 5982 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:49:51 6297 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:54:55 6484 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 00:59:59 6218 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 01:05:03 6139 qmem://<bundled>/BuiltIn/led_g.png green
03-09-2012 01:10:07 6781 qmem://<bundled>/BuiltIn/led_o.png warning
03-09-2012 01:15:11 6998 qmem://<bundled>/BuiltIn/led_o.png warning
03-09-2012 01:20:15 6906 qmem://<bundled>/BuiltIn/led_o.png warning
03-09-2012 01:25:20 7139 qmem://<bundled>/BuiltIn/led_r.png error

- column2 : expression = number1+number2+number3+number3

- column4 : depending of the value in the column 2 I display : green, warning or error (threshold value)

=if (num(Column(1)) < warningv,'green',

if (num(Column(1)) < errorv,'warning',

if (num(Column(1)) > errorv,'error',Null())))

Now from this cross table I would like create a graph representing the number of percentage of green, warning and error.

Could you help me how can I do it please?

thks

Valery

0 Replies