Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Expression in Text box

Hi,

Please let me know what is missing in the below statement:

='GRAND TOTAL: ' & count(
{<
[FLAG1]={'E'}
>}
DISTINCT TEST_CASE_ID) +
count(
{<
[FLAG1]={'C'}
>}
DISTINCT TEST_CASE_ID)

The 'Grand Total' and the expression are working fine individually but not together as shown above.  Please let me know if I am missing something in the syntax.

Thanks,

Sudha.

Tags (1)
2 Replies
Digvijay_Singh
Honored Contributor III

Re: Expression in Text box

You can do like this-

='GRAND TOTAL: ' &  num(count({<[Prod]={'A'}>} DISTINCT Value) + count({<[Prod]={'B'}>} DISTINCT Value))

Re: Expression in Text box

Please don't repost the same question again and again. Did you try the suggestion from this thread? -> Syntax in Text box