Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
balasundaram
Creator II
Creator II

set expression for not effected by other selections

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

6 Replies
PrashantSangle

Hi,

Nullify otherfield in your set analysis.

Like

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

This way you can achive currente YEar Sales regardless other selection

Great dreamer's dreams never fulfilled, they are always transcended.
ajaykumar1
Creator III
Creator III

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
Not applicable

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
MVP
MVP

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

stigchel
Partner
Partner

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

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

CELAMBARASAN

Try

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

here 1 represents ignores all selections