Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ronytullus1
New Contributor

Set Expression Question

Hello,

Can anyone tell me why the first two parts of this set expression return the appropriate values but when I add the expression to only sum those fields names that include communications Qlik returns nulls values? I check my data and for the specified Year and Period I have values?

Sum({$<[Year]={'2018'}>}{$<[Year-Period]={$(vYTD Month List)}>}{$<[Tower]={'Communications'}>}Actuals)

Tags (1)
3 Replies
vamsee
Valued Contributor

Re: Set Expression Question

Try this

Sum({$<[Year]={'2018'},[Year-Period]={$(vYTD Month List)}, [Tower]={'Communications'}>}Actuals)

Highlighted
ronytullus1
New Contributor

Re: Set Expression Question

Thanks that worked!

vamsee
Valued Contributor

Re: Set Expression Question

Glad it worked for you.

----------------------------------------

If you think this was helpful, please mark the correct answer or helpful.

Qlik Community Tip: Marking Replies as Correct or Helpful