Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to use Aggregate function in the Text Box

Hello,

I am using the following expression in the text box.

=count (  IF ([Primary Item Quantity]  + sum( [Alternate Item Quantity] )  < [Safety Stock Quantity], [Inventory Item]))

My objective is to find count of item  with Primary and Alternate quantity is less than safety stock.

Please note, Alternate item  is a separate table with one to many relationships with Primary Item.

Above expression gives error.

Kindly Advice.

Abubakker.

1 Reply

Re: How to use Aggregate function in the Text Box

Perhaps this:

count({<[Inventory Item]={'=only([Primary Item Quantity])+sum([Alternate Item Quantity])<only([Safety Stock Quantity])'}>}[Inventory Item])

If not, please post a document that demonstrates the problem.


talk is cheap, supply exceeds demand
Community Browser