Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vikram_tulsiani
Contributor
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
Creator III
Creator III

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
Creator III
Creator III

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