Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make a variable not depend on current selections

Hi Community,

The following is the code for my variable:

=sum(if([Calendar Date]>vFYStart  and [Calendar Date]<vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays

vNumDays doesn't change, but the [Calendar Date] changes depending on my selection in the document.  How to get this variable to be regardless of selection?

1 Solution

Accepted Solutions
Not applicable
Author

=sum({1}if([Calendar Date]>vFYStart  and [Calendar Date]<vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays

View solution in original post

1 Reply
Not applicable
Author

=sum({1}if([Calendar Date]>vFYStart  and [Calendar Date]<vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays