topic Re: Variable inside Set Analysis in QlikView

Variable inside Set Analysis

bkn — Mon, 06 Apr 2015 17:36:26 GMT

Anyone please help to solve this issue.

// Not Working

SUM({$<Account={'Major','Non-Major'}>}$(vData)) // vData is a variable which pulls data

Thanks!!!

Re: Variable inside Set Analysis

danielact — Mon, 06 Apr 2015 17:41:44 GMT

Can you post what vData is defined as?

Re: Variable inside Set Analysis

bkn — Mon, 06 Apr 2015 17:46:00 GMT

If(MonthName='FEB', SUM({<MonthName={'NOV'},FYYear={'$(vFYCurrentYear)'},Account="Major","Non-Major"}>}[CurrentData])

Re: Variable inside Set Analysis

stigchel — Mon, 06 Apr 2015 17:47:32 GMT

$(vData) should be the name of a fiield, check by putting =vData in a textbox. Are there spaces in the field name, put square brackets around [$(vData)]

Re: Variable inside Set Analysis

danielact — Mon, 06 Apr 2015 17:49:28 GMT

You're using a nested sum, which won't work. You can't have a Sum in your original function as well as in the variable you're calling.

Re: Variable inside Set Analysis

Anonymous — Mon, 06 Apr 2015 17:53:44 GMT

your vData should be a field of your data model

Re: Variable inside Set Analysis

Anonymous — Mon, 06 Apr 2015 19:24:35 GMT

Looking at your vData expression,

create another field (i.e. a flag) =1 for Month='FEB' in your script (considering this is the only condition you want to use), then write your expression as below,

SUM({<MonthName={'NOV'},FYYear={'$(vFYCurrentYear)'},Account={"Major","Non-Major"}>}[CurrentData]*New_Field)