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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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?

Labels (1)
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