topic Re: ADD two different sets of expressions in QlikView

ADD two different sets of expressions

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

Hi,

I have two different sets in two charts:

a) =count({$<[F-dimension]={'Yes'}>} [C-value])

b) =count(if(C-Days>='90' , [C-value])

Now I need to use both these conditions on a single chart.

I tried =count({$<[F-dimension]={'Yes'}>} [C-value]) AND count(if(C-Days>='90' , [C-value]) but this does not give correct value.

Please can someone help.

Anil_Babu_Samineni — Tue, 27 Sep 2016 17:49:35 GMT

count({$<[F-dimension]={'Yes'}, c-days = {if(c-days >= '90', c-days)}>} [C-value])

Note, typo errors are there try fyi resolve that

sunny_talwar — Tue, 27 Sep 2016 17:51:44 GMT

May be this:

=Count({$<[F-dimension]={'Yes'}, C-Days = {'>=90'}>} [C-value])

Anonymous — Tue, 27 Sep 2016 18:01:49 GMT

Thanks this worked.