Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
keerthanagowsi
Contributor III
Contributor III

Restricting one of the filters(week) to only one chart

Hi all,

I am new to qlik sense.

I am displaying 2 charts in a sheet and having common set of filters.

One chart should show data for all weeks irrespective of the week selected in the filter.

Second chart should show data for latest week by default and the user can also change the week in the filter.I achieved the second chart by using bookmark and alternate state. 

For my 1st chart,I tried using set(may be using wrong expression),but cannot achieve my first requirement(chart should show data for all weeks ). Ideally should ignore the week filter.

Any help is appreciated as i got stuck here.

Thanks,

Keerthana

1 Solution

Accepted Solutions
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

 

In your Set Analysis, you should ignore selection from the week. i.e.

SUM({<WeekFieldName=>} Sales).

If that didn't work please upload .qvf or your Set Analysis

 

View solution in original post

2 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

 

In your Set Analysis, you should ignore selection from the week. i.e.

SUM({<WeekFieldName=>} Sales).

If that didn't work please upload .qvf or your Set Analysis

 

keerthanagowsi
Contributor III
Contributor III
Author

Thanks Gabriel. This works. I was also using the same expression, but i used the wrong date field and that was the problem.