topic Re: List box expression in QlikView

List box expression

vijetas42 — Mon, 28 Sep 2015 15:53:06 GMT

Hi All,

My requirement is, Currently I am having year values in dimension as 2010 to 2020 but, in my fact tables data is present only for 2014 and 2015 for that i want to show only year values for those data is present without hard coding .How to achieve this.

Re: List box expression

swuehl — Mon, 28 Sep 2015 16:09:45 GMT

Assuming a Fact field like Sales, try something like

=aggr( only({<Sales = {"*"}>} Year), Year)

as list box field expression.

Re: List box expression

vijetas42 — Tue, 29 Sep 2015 06:13:55 GMT

Hey,

Thanks for your reply.It's working fine but,can you tell me what is meaning of this expression only({<Sales = {"*"}>} Year)

Re: List box expression

swuehl — Tue, 29 Sep 2015 08:06:27 GMT

{<Sales = {"*"} >} is a set expression.

It's filtering records for which a Sales record ( of any value, "*" is a wildcard search) is existing. So only SalesDates / Years which appear in the fact table should be returned.