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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make a conditional chart

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 ?

3 Replies
its_anandrjs
Champion III
Champion III

Hi,

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

Regards,

Anand

ToniKautto
Employee
Employee

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))

its_anandrjs
Champion III
Champion III

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