Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Gabriel. This works. I was also using the same expression, but i used the wrong date field and that was the problem.