topic How to make a conditional chart in QlikView

How to make a conditional chart

Wed, 10 Aug 2011 18:08:36 GMT

I have a table with a field called T0, in this format DD, hh:mm:ss, the idea is to make a table that only count the values major to 00, 00:30:00, I used the expression :

Count(if(T0 >= 00, 00:30:00, T0))

but the expression editor shows an error.

How can I do that ?

How to make a conditional chart

its_anandrjs — Wed, 10 Aug 2011 18:36:47 GMT

Hi,

Do you have any sample of this it will be more easy.

Regards,

Anand

How to make a conditional chart

ToniKautto — Wed, 10 Aug 2011 18:51:01 GMT

You need to quote strings, otherwise you will get an error. I am not convinced that your expression will work, depending on what data type T0 has. So if it does not work, please attach a QVW sample to enable more detailed advice.

The expression needs quoting;

Count(if(T0 >= '00, 00:30:00', T0))

How to make a conditional chart

its_anandrjs — Wed, 10 Aug 2011 19:13:16 GMT

Hi,

Yes you need to write a check code it single quotes like Count(if(T0 >= '00, 00:30:00', T0)) like Toni suggested it is also depents on your data type of 00, 00:30:00 field it is then you need to check, if you have any sample will be easy.

Regards,

Anand