topic and clause in QlikView

and clause

Mon, 03 Nov 2014 14:37:14 GMT

I'm trying to create an 'and' function and struggling.

I've got the basic code which is:

Count({<ExceptionMonth = {$(vCurrentMonth)}> } [Exception ID])

However i want to add another clause which is "and testID ='1'."

How / where would i do tis?

Cheers

MK_QSL — Mon, 03 Nov 2014 14:41:58 GMT

Count({<ExceptionMonth = {$(vCurrentMonth)}, testID = {'1'}> } [Exception ID])

Count({<ExceptionMonth = {'$(vCurrentMonth)'}, testID = {'1'}> } [Exception ID])

its_anandrjs — Mon, 03 Nov 2014 14:44:32 GMT

Try with

Count({<ExceptionMonth = {' $(vCurrentMonth), testID = {'1' } ' }> } [Exception ID])

Count({<ExceptionMonth = {' $(vCurrentMonth) '}, testID = {'1'} }> } [Exception ID])

Regards

Anand