Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
employe4_2
Contributor III
Contributor III

pre selection independant from active selection

HI ,

i'm using this expression to have my sum of sales per date on a specifique periode of time ( where max_cal_date  give me the last 3 loaded days):

sum(if ([Date]= Max_Cal_Date, Sales,0))

but at this point i'm willing to make it independant from the active selection,

if the user select some other days, i would like my chart NOT to take it in consideration.

Because this chart is made to display the last 3 days, whenever the selection made is out of these 3, the intire chart desappear, wich is not the goal.

I saw on an other post to add: + sum({1}0) 

but not working, any advice ?

 

Labels (1)
1 Reply
Anonymous
Not applicable

Hi,

try this 

=Sum({1<[Date]= {"=$(=Max_Cal_Date)"}>}Sales)

The 1 ignore all selections.