topic Sum of Rows in Chart to Text box in QlikView

Sum of Rows in Chart to Text box

Tue, 03 Jan 2017 08:15:13 GMT

Hi,

I am Currently using the following expression in the Chart with item_description as a dimension. However i want to use the sum of the expression in a text box but am unable to get the desired answer.

=if((Count({<item_description = {"=rank(count({<System-={'GMS'},Metric={'Catalog'},Year={'2016'},Cat_Non_Cat_flag={'NON-CAT'},Scope={'IS'}>}UniqueRowNum), 4)<= $(Catalog_SL2)"},Cat_Non_Cat_flag={'NON-CAT'},Year={'2016'},System-={'GMS'},Metric={'Catalog'},Scope={'IS'}>}UniqueRowNum))>0

and (Count({<item_description = {"=rank(count({<System-={'GMS'},Metric={'Catalog'},Year={'2016'},Cat_Non_Cat_flag={'NON-CAT'},Scope={'IS'}>}UniqueRowNum), 4)<= $(Catalog_SL2)"},Cat_Non_Cat_flag={'CAT'},Year={'2016'},System-={'GMS'},Metric={'Catalog'},Scope={'IS'}>}UniqueRowNum)) >0,

(Count({<item_description = {"=rank(count({<System-={'GMS'},Metric={'Catalog'},Year={'2016'},Cat_Non_Cat_flag={'NON-CAT'},Scope={'IS'}>}UniqueRowNum), 4)<= $(Catalog_SL2)"},Cat_Non_Cat_flag={'NON-CAT'},Year={'2016'},System-={'GMS'},Metric={'Catalog'},Scope={'IS'}>}UniqueRowNum)))

Thanks in advance.

Re: Sum of Rows in Chart to Text box

Anil_Babu_Samineni — Tue, 03 Jan 2017 10:22:17 GMT

Desire Result means? Can you send the images as you need to get?

Re: Sum of Rows in Chart to Text box

parimikittu — Tue, 03 Jan 2017 10:36:25 GMT

Is better you give us ur working app or sample data and desired ouput

Re: Sum of Rows in Chart to Text box

Tue, 03 Jan 2017 11:37:03 GMT

the above expression gives me a table with item description in the dimension and count based on the expression provided will i be able to get the same sum total if i use the expression in a textbox?

Re: Sum of Rows in Chart to Text box

parimikittu — Tue, 03 Jan 2017 11:41:52 GMT

Yes, u can get the sum if the above expression is used in Tex box but add sum(ur if condition).

Re: Sum of Rows in Chart to Text box

Tue, 03 Jan 2017 11:45:03 GMT

I get an error saying nested aggregation not allowed