topic Re: Displaying text value with Sum value in Text box in QlikView

Displaying text value with Sum value in Text box

Tue, 12 Aug 2014 10:34:58 GMT

Hi QV

I want to show the sum of values in text box text (likeNo Of Receipts--250)......will it work??

No Of Receipts &'-'& Sum(RECEIPT_CNT)

Tue, 12 Aug 2014 10:36:44 GMT

= 'No Of Receipts' &'-'& Sum(RECEIPT_CNT)

This will work

Tue, 12 Aug 2014 10:52:25 GMT

can we use multiple fileds like below??

='OTD%' &'-'& Sum(MET_OTD_RQST_CNT), 'Short Cycle%' &'-'& Sum(SHRT_CYC_CNT) , 'Request Met' &'-'& Sum(MET_RQST_CNT)

getting some garbage after expression issue.

Tue, 12 Aug 2014 10:56:05 GMT

got it tnax

=('OTD%' &'-'&

Sum(MET_OTD_RQST_CNT) &'-'& 'Short Cycle%' &'-'& Sum(SHRT_CYC_CNT) &'-'& 'Request Met' &'-'& Sum(MET_RQST_CNT) )

anbu1984 — Tue, 12 Aug 2014 10:57:12 GMT

Yes you can. But use ampersand instead of comma

='OTD%' &'-'& Sum(MET_OTD_RQST_CNT) & 'Short Cycle%' &'-'& Sum(SHRT_CYC_CNT) & 'Request Met' &'-'& Sum(MET_RQST_CNT)