Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
For my Company, I'm preparing an application which contains review count and the total exposure based on each analyst. The Total Exposure value updates automatically everyday. I have added a filter pane for date.So, that exposure of a particular date can be seen. But I want the date selection to change only the exposure values but the remaining visualizations should remain the same. I tried set analysis but it did not work.
Help me out!
Thanks!
Hi Akshay!
I'm sure there'd be multiple approach's for this.
One would be "alternate states". create a state specifically for date filter and exposure values. and other fro remaining.
Good luck
Avinash
Try the concept of alternative states.
Alternative states is still not available in the current Qlik Sense versions.
You can use set analysis and Modifier to force exclusion for the date field to other expressions in the charts
Below is the details from the Qlik Help
Hi!
I have tried this and it worked, by using p(field name). You can select the filters which you want and exclude the rest
count(
{1<[NonDep Reviews.Analyst]=p([NonDep Reviews.Analyst])>}
{1<[NonDep Reviews.Type of Review]=p([NonDep Reviews.Type of Review])>}
[NonDep Reviews.Status]))