Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this
Sum({$<[Year]={'2018'},[Year-Period]={$(vYTD Month List)}, [Tower]={'Communications'}>}Actuals)
Thanks that worked!
Glad it worked for you.
----------------------------------------
If you think this was helpful, please mark the correct answer or helpful.