topic Re: set expression for not effected by other selections in QlikView

set expression for not effected by other selections

balasundaram — Fri, 12 Sep 2014 11:14:56 GMT

i need set expression to show current year data..but not effected by other selections.

PrashantSangle — Fri, 12 Sep 2014 11:17:57 GMT

Hi,

Nullify otherfield in your set analysis.

Sum({<DateField={">=$(=yearstart(today()))"},Month=,Day=>}Sales)

This way you can achive currente YEar Sales regardless other selection

ajaykumar1 — Fri, 12 Sep 2014 11:18:59 GMT

Hi,

Try like this.

e.g. 1. sum({<Year ={'2014'},month=,date=,product=>}sales)

2......sum({<Year ={"$(=year(today()))"},month=,date=,product=>}sales)

If your selecting the month,date,product fields then it will not reflect in the expression.

Regards,

Ajay

Anonymous — Fri, 12 Sep 2014 11:19:22 GMT

you Need to define those selections who shall not modify your result by "Selection=" (selection will have no effect to calculation)

sum{<year={}selectedyear},Selection1=,Selection2=,Selectionn..>}Anything

MK_QSL — Fri, 12 Sep 2014 11:26:22 GMT

SUM({1<Year = {'$(=Year(Today()))'}>}Sales)

stigchel — Fri, 12 Sep 2014 11:26:43 GMT

You do not need to qualify all fields just use the 1 set qualifier like this:

Sum({1<Year={$(=Max(YearField))}>}

CELAMBARASAN — Fri, 12 Sep 2014 11:27:54 GMT

Try

Sum({1<YearFieldName={$(=Year(Today()))}>} Sales)

here 1 represents ignores all selections