topic Re: Fix in Set analysis one year withoul selection in QlikView

Fix in Set analysis one year withoul selection

Wed, 22 Apr 2015 13:18:28 GMT

Good afternoon,

I have a dashboard with the ítem "years", and i want without selecting any year in the dashboard, to have the 2015 sales data in a table.

How is this posible in set analysis?

Thanks

Belén

Anonymous — Wed, 22 Apr 2015 13:20:41 GMT

Set will be

{<Year={2015}>}

Edit: Or if it should be a current year (that is 2016 in next year and so forth):

{<Year={"$(=Year(today()))"}>}

buzzy996 — Wed, 22 Apr 2015 13:24:49 GMT

try this,

=Sum({$<Year={"2015"}>}Sales)

Wed, 22 Apr 2015 13:24:59 GMT

Thanks