topic Re: Count conditional text Field in QlikView

Count conditional text Field

frank1982 — Tue, 27 Mar 2018 16:57:18 GMT

Hi,

for the following table

I have to count the number of rows that NOT include the char 'M'.

I built a table with a Dimension, and the expression is the Count of rows:

How could I calculate the column '# Offerte disponibili'?

Thank you in advance.

Franco

sunny_talwar — Tue, 27 Mar 2018 17:09:20 GMT

May be this

Count({<CD_SOURCING_FN_AUT = E({<CD_SOURCING_FN_AUT = {"*M*"}>})>} CD_SOURCING_FN_AUT)

frank1982 — Wed, 28 Mar 2018 08:03:25 GMT

It works!

Great!

Thank you very much!

Franco

frank1982 — Wed, 28 Mar 2018 08:21:38 GMT

I'm sorry, I have another question : how I have to write the expression if I would like to add another condition?

For example, I want to obtain the strings that don't include chars 'M' and string 'prova'.

thank you.

Franco

sunny_talwar — Wed, 28 Mar 2018 08:41:08 GMT

May be this

Count({<CD_SOURCING_FN_AUT = E({<CD_SOURCING_FN_AUT = {"*M*", "*prova*"}>})>} CD_SOURCING_FN_AUT)