topic Re: Expression to make chart static in QlikView

Expression to make chart static

vikram_tulsiani — Sat, 16 Nov 2024 21:18:07 GMT

Hello,

I have a chart that I need to make static (does not change with selections made). This is the expression I am using but I cannot seem to fix it. Is there any way to use set analysis to keep it fixed?

=If(Week([Date Created On]) = Week(Today())-1,count([Material Description]))

The expression shows how many SKUs were created the past week.

Any help is greatly appreciated!

Thanks!

Re: Expression to make chart static

CarlosAMonroy — Tue, 05 Mar 2019 21:28:27 GMT

Hi,

You can use the modifier {1} in set analysis that will allow you to exclude every selection made by user.

=If(Week([Date Created On]) = Week(Today())-1,count( {1} [Material Description]))

Thanks,
Carlos M

Re: Expression to make chart static

tincholiver — Tue, 05 Mar 2019 23:50:22 GMT

count({1<WEEK={'>=$(=max(WEEK)-1)<$(=max(WEEK))'}>}[Material Description])