topic Re: Text Box Expression in QlikView

Text Box Expression

Thu, 07 Jan 2016 22:54:17 GMT

Hello all,

I am trying to figure out a total sum of loss items with a certain date range. I would like to show that figure in a Text Box format. Currently, I need to reflect current month. But would also like the flexibility of saying Total Amount of Losses within for example 1/1/2016 and 1/15/2016.

I hope that makes sense.

Thank you,

Manny

Re: Text Box Expression

robert_mika — Fri, 08 Jan 2016 00:08:05 GMT

Try

sum( {$<StartDate = {“>1/1/2016”}, EndDate = {“<1/15/2016.”} >} Sales )

Re: Text Box Expression

Fri, 08 Jan 2016 19:23:02 GMT

Thank you for the reply Robert. I am getting a "Error in set modifier ad hoc element list". I tried to enter instead of sales amount, what I am actually using. As, well as formatting the date format but it still is giving me that error.

Thanks again for your help on this.