Set Expression Question

[Anonymous]

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)

[vamsee]

Try this

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

[Anonymous]

Thanks that worked!

[vamsee]

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