topic Re: Set Analysis with field=, in QlikView

Set Analysis with field=,

surajap123 — Mon, 07 Apr 2014 10:26:34 GMT

Hi,

1.I wanted to know the difference between the below 2 expressions. Both of them giving the same result for me in my chart, then why we prefer the second one.

2. Also, what does field=no value(Eg- Day=,) do in set analysis?

=SUM({<Year={'$(vPriorYear)'},Date={'<=$(vPriorYearDate)'}>}Amount)

=SUM({<Year={'$(vPriorYear)'},Month=,Day=,Date={'<=$(vPriorYearDate)'},MonthYear=>}Amount)

Re: Set Analysis with field=,

ThornOfCrowns — Mon, 07 Apr 2014 10:33:42 GMT

FieldName=, means ignore what is selected for that field.

Re: Set Analysis with field=,

Mon, 07 Apr 2014 10:36:42 GMT

Means bypassing the selections of that field.

ie, It will consider the total data of that field regardless of selections.

Re: Set Analysis with field=,

alexandros17 — Mon, 07 Apr 2014 10:36:49 GMT

Both expression are equal

=SUM({<Year={'$(vPriorYear)'},Date={'<=$(vPriorYearDate)'}>}Amount)

=SUM({<Year={'$(vPriorYear)'},Month=,Day=,Date={'<=$(vPriorYearDate)'},MonthYear=>}Amount)

... unless you select a Month, Day or MonthYear, in that cases values will change because in the first expression you consider that selection in the second expression you compute Amount without taking care of Month, Day or MonthYear selections (field= means don't use if selected)

Hope it helps

Re: Set Analysis with field=,

tresB — Mon, 07 Apr 2014 10:36:54 GMT

1. If you have fields Month, Day then with first expression user would not get the right result if they get to select from either of them. That again depends on how you have declared your variable.

2. Day=, -> indicates that any selection in the field Day would be disregarded.

I would recommend you to go through help file or reference mauanl first, that would clear your basic doubts.

Re: Set Analysis with field=,

surajap123 — Mon, 07 Apr 2014 11:25:19 GMT

Thanks a lot for the valuable inputs.

I am actually looking at PriorPeriodComarision app build by Steve Dark, which I have attached here-

I am still not clear about the significance of field=,. I mean, even with Field=, in the expression, when i make selection on Day 1 in the list box the values

Change from 153,368.40 to 149,568.46 with below expression--

=SUM({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Amount)

and Change from 153,368.40 to 5,273.08 with below expression--

=SUM({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'}>}Amount)

I am not sure, how the app is calculating?

Sorry, If my question is very basic.

Re: Set Analysis with field=,

nizamsha — Mon, 07 Apr 2014 11:50:08 GMT

month=

This is ignoring the selection suppose u have sales 1000

expression

sum({$<year={"$(=Max(Year),month=)"}>}sales)

When u click on the year current selection is the year and the sales amount will change based on the year

but when u click on the month sales values wont change

Re: Set Analysis with field=,

surajap123 — Mon, 07 Apr 2014 12:12:29 GMT

Hi Nizam,

I see that selections are not ignoried. when I make selection on Day and Month, the values of Amount is changing. The chart contains the below expression.

=SUM({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Amount)