Like operator in set analysis - Field used in the Measure and as filter

[FatiQlik]

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:

Budget=Sum({$<KPI_Name={'Budget'},BudgetType={"*Budget*"}>} [ForecastAmount])

Forecast=Sum({$<KPI_Name={'Budget'},BudgetType={"*FC*"}>} [ForecastAmount])

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'

[sunny_talwar]

What issue are you running into when you use these expressions?

[jochem_zw]

This is a data modelling issue, would be better to have your budget and forecast tables like this:

Budget_Type	Year	Amount
Budget V1	2019	100
Budget V2	2019	110
Budget V1	2020	200
Budget V2	2020	220

With this data it is possible to filter on budget type and on year

[rwunderlich · Accepted solution]

Use "*=" operator to indicate you want to intersect with current selections:

BudgetType*={"*Budget*"}>}

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com