Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
vikram_tulsiani
New Contributor

Expression to make chart static

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!

Labels (1)
2 Replies
CarlosAMonroy
Contributor III

Re: Expression to make chart static

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

Re: Expression to make chart static

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