topic Re: Using If Condition, the set analysis expression is not working in QlikView

Using If Condition, the set analysis expression is not working

Fri, 09 Aug 2013 13:20:47 GMT

Hi,

In the below expression is not working because of exclution of -=, could you please any one suggest where its wrong.

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),

If(Title='Nb_Ship',Count([TransNo))

Regards

Chriss

Re: Using If Condition, the set analysis expression is not working

Gysbert_Wassenaar — Fri, 09 Aug 2013 13:25:52 GMT

Try adding a final ) at the end of your expression:

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),If(Title='Nb_Ship',Count([TransNo)))

The expression editor has a bug so -= will show a red underline. But the syntax is correct. If the expression doesn't calculate the correct result it's not because [Status]-={'A'} isn't the right syntax.

Re: Using If Condition, the set analysis expression is not working

MayilVahanan — Fri, 09 Aug 2013 13:26:30 GMT

If your full expression is

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),

If(Title='Nb_Ship',Count([TransNo)) only means,

You didn't closed the if condition

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),

If(Title='Nb_Ship',Count([TransNo)))