Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Fix in Set analysis one year withoul selection


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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Fix in Set analysis one year withoul selection

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()))"}>}

3 Replies
mov
Esteemed Contributor III

Re: Fix in Set analysis one year withoul selection

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
Honored Contributor II

Re: Fix in Set analysis one year withoul selection

try this,

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

Not applicable

Re: Fix in Set analysis one year withoul selection

Thanks

Community Browser