Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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'

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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

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

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

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

View solution in original post

3 Replies
Highlighted

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

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

Highlighted
Partner
Partner

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

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

Budget_TypeYearAmount
Budget V12019100
Budget V22019110
Budget V12020200
Budget V22020220

 

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

Highlighted
MVP & Luminary
MVP & Luminary

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

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

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

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

View solution in original post