topic Re: How can I have a dynamic subtotal based on threshold? in QlikView

How can I have a dynamic subtotal based on threshold?

posywang — Tue, 01 Dec 2020 01:56:45 GMT

Hi,

I was trying to create a pivot table that only shows data over threshold. I was able to create an expression that show and hide based on the input threshold. However, the subtotal doesn't change at all and always shows the original subtotal. I attached a sample file for your reference. Please advise. Thank you!

Re: How can I have a dynamic subtotal based on threshold?

MayilVahanan — Tue, 01 Dec 2020 02:03:02 GMT

Hi @posywang

Try like below

sum({<OrderDate={"=Sum(UnitTotal)>=$(v1)"}>}UnitTotal)

Re: How can I have a dynamic subtotal based on threshold?

posywang — Tue, 01 Dec 2020 17:51:25 GMT

It works! Thank you so much for your help!!