Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tuongnguyen
New Contributor II

Set analysis chanlenge

Hello,

I'm facing to this chanlenge. My data have 5 field

IDTypeDateAgeValue

I would like to have a  formula to sum the value with fixed Type and Date. Age can be selected in dashboard.

So I do

1.   sum({1<Type={1},Date={201801>}Value)  => Age cannot be selected

2.   sum({$<Type={1},Date={201801>}Value)  => We can select all Type, Date, and Age => so Type and Date cannot be fixed as I want.

Do you have any suggestion to solve my problem?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis chanlenge

Not entirely sure what you want, do you want to ignore selection in Age field in addition to the set analysis on Type and Date? May be try this

Sum({$<Type={1},Date={201801}, Age>}Value)

1 Reply
MVP
MVP

Re: Set analysis chanlenge

Not entirely sure what you want, do you want to ignore selection in Age field in addition to the set analysis on Type and Date? May be try this

Sum({$<Type={1},Date={201801}, Age>}Value)