Discussion board where members can get started with Qlik Sense.
How can i use a filter BudgetType in my report wile this field is also used on my measure.
in this example BudgetType contains (Budget 2016, Budget 2017, Budget 2018, Budget 2019, Budget 2019 v2, FC1 2019, FC2 2019, FC3 2019)
i would like to create to measures like this:
At the same time i would like to be able to use BudgetType as filter on my report. and if i choose both 'Budget 2019 v2' and 'FC2 2019'
will my measure Budget show 'Budget 2019 v2'
and will my measure Forecast show 'FC2 2019'
Use "*=" operator to indicate you want to intersect with current selections:
View solution in original post
What issue are you running into when you use these expressions?
This is a data modelling issue, would be better to have your budget and forecast tables like this:
With this data it is possible to filter on budget type and on year