topic Re: Expression in Text box in QlikView

Expression in Text box

Mon, 28 Sep 2015 20:42:48 GMT

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.

Re: Expression in Text box

Digvijay_Singh — Tue, 29 Sep 2015 04:26:48 GMT

You can do like this-

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

Re: Expression in Text box

sunny_talwar — Tue, 29 Sep 2015 04:28:56 GMT

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