topic Using variable for Field value(Column) in Set Analysis in QlikView

Using variable for Field value(Column) in Set Analysis

satishsure — Fri, 31 Mar 2017 16:41:03 GMT

I have variable called $vYearTotal. and I need to use in set expression to fetch for previous year.

=sum( {1<Year = {2015}>} $(vYearTotal) ).

I am trying to create new column using the above set expression.Not working for me.

Re: Using variable for Field value(Column) in Set Analysis

sunny_talwar — Fri, 31 Mar 2017 16:43:56 GMT

How do you define vYearTotal?

Re: Using variable for Field value(Column) in Set Analysis

satishsure — Fri, 31 Mar 2017 16:59:32 GMT

Getting from another expression below
Num(

Sum( {$< Flag={1}, Year=, Quarter=, Month=, [Quarter In Year]=, [Month In Quarter]=>} $(vSelectField)

) / [Div],

Pick(WildMatch([Div], 1, 1000, 1000000), '#,##0', '#,##0', '#,##0.0')

)

Re: Using variable for Field value(Column) in Set Analysis

sunny_talwar — Fri, 31 Mar 2017 17:09:33 GMT

You can try this

=Sum({1<Year = {2015}>} Aggr( $(vYearTotal), YourChartDimension))

Re: Using variable for Field value(Column) in Set Analysis

satishsure — Fri, 31 Mar 2017 17:20:36 GMT

Sunny..I don't have chart expression. As I need to create new Column $(vYearTotal) which should get results of previous year irrespective of selection.

=Sum({1<Year = {2015}>} Aggr( $(vYearTotal), YourChartDimension))

Re: Using variable for Field value(Column) in Set Analysis

satishsure — Fri, 31 Mar 2017 18:18:41 GMT

Sunny I have tried adding Aggr on Variable but no luck.Can some body suggest me.

Re: Using variable for Field value(Column) in Set Analysis

satishsure — Fri, 31 Mar 2017 19:10:26 GMT

Sunny..I have attached the qvw and Expression column is "Selection" in the Main straight table

Re: Using variable for Field value(Column) in Set Analysis

sunny_talwar — Fri, 31 Mar 2017 19:43:53 GMT

What is this qvw showing my friend? I am not sure where is the variable vYearTotal

Re: Using variable for Field value(Column) in Set Analysis

satishsure — Fri, 31 Mar 2017 19:46:50 GMT

It is a front end variable

Re: Using variable for Field value(Column) in Set Analysis

sunny_talwar — Fri, 31 Mar 2017 19:49:21 GMT

Is this not the requirement?

Sum({<Year = {2015}>}Aggr($(vYearTotal), Year))

Re: Using variable for Field value(Column) in Set Analysis

satishsure — Fri, 31 Mar 2017 19:56:17 GMT

Yeah ..My requirement is like Second Column which is (Year=2015). But I need to Use the variable as field value for expression.irrespective of selection it should display the vYearTotal value for year 2015

=Sum( {1 <Year={2015}>} $(vYearTotal) )

Re: Using variable for Field value(Column) in Set Analysis

sunny_talwar — Sat, 01 Apr 2017 15:32:18 GMT

I am not sure what you mean my friend... can you please explain clearly