topic Re: Line Chart Time And Conditional Value in QlikView

Line Chart Time And Conditional Value

rebelfox — Wed, 25 Nov 2020 16:16:04 GMT

I have a table that has a month/year column and it has a single quantity column that holds a value that can be anything from 0 to 999.

I want one line on my chart to show the count of rows with a value of 0 over time.

The dimension is straight forward as it is a time dimension against a calendar.

The expression I am not clear how to code an expression to only count rows where the quantity column is 0.

Can anybody advise?

Thanks

ziadm — Fri, 20 May 2016 14:55:05 GMT

use set Analysis is your expression

assuming this is your Table

Load * Inline [

Date, Quantity

01-05-2016, 1

01-05-2016, 0

02-05-2016, 0

03-05-2016, 1

03-05-2016, 0

];

in you line chart your dimension should be Date

and you expression should be

Count({<Quantity= {0} >} Date)

rebelfox — Sun, 22 May 2016 10:00:00 GMT

Took me a while to confirm the results but yes that does the trick.

Many thanks.