Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm fairly new to Qlik but I'm having problems with my stacked bar chart not filtering when I make a selection. I need some common things I should look at when encountering this problem. I'm using a set analysis and I'm not sure if that's the cause of my problem. My set analysis reads as Sum({$<[Actuals.PR3]={'Core Maintenance'},Year={'2018','2017'},[Year-Period]={$(vYTD Month List)}>}Actuals). I selected Actuals.PR3 as a dimension on my filtering pane but when I select various Actuals.PR3 dimensions including "Core Maintenance" above nothing happens to my bar chart?
You could share your app please
Rony -
Filtering on [Actuals.PR3] will have no impact on this set analysis since you have hard coded it to only show 'Core Maintenance'.
Sum({$<[Actuals.PR3]={'Core Maintenance'},Year={'2018','2017'},[Year-Period]={$(vYTD Month List)}>}Actuals)
If you want to be able to filter on [Actuals.PR3] to see different [Actuals.PR3]s, you would need to update your set analysis to...
Sum({$<Year={'2018','2017'},[Year-Period]={$(vYTD Month List)}>}Actuals)
Hope that helps.
Thanks this worked perfect. Sorry for the late response.