topic Re: Use selection as parameter in expression in QlikView

Use selection as parameter in expression

patrickbender — Wed, 08 Aug 2018 14:06:32 GMT

Hi,

I have selected a date from a multibox and would like to use set analysis with the whole set (1) in order to sum a field that is

SUM({1<datefield={Highest value less than date selection}>}Sumfield)

Is that possible?

vishsaggi — Wed, 08 Aug 2018 14:12:28 GMT

May be this?

= SUM({<datefield= { [$(=GetFieldSelections(YourfieldselectionFieldname))] } >}Sumfield)

patrickbender — Wed, 08 Aug 2018 14:17:35 GMT

Almost there

It also needs to be latest date less than the selection.

sunny_talwar — Wed, 08 Aug 2018 14:22:09 GMT

May be using nested set analysis

Sum({1<datefield = {"$(=Date(Max({<datefield = {[$(='<' & Date(Min(datefield))]}>}datefield)))"}>} Sumfield)

sunny_talwar — Wed, 08 Aug 2018 14:23:56 GMT

Missed a parenthesis

Sum({1<datefield = {"$(=Date(Max({<datefield = {[$(='<' & Date(Min(datefield)))]}>} datefield)))"}>} Sumfield)

vishsaggi — Wed, 08 Aug 2018 14:25:48 GMT

My bad completely misunderstood the question. Try sunny's expression and let us know. 🙂

petter — Wed, 08 Aug 2018 14:26:03 GMT

A search string within a set expression will do:

Sum( {<Date={'$(=Max({<Date={"<$(=Date)"}>} Date))'}>} Sales)

Replace Date with datefield and Sales with Sumfield above ...

patrickbender — Wed, 08 Aug 2018 14:34:20 GMT

Thank you!