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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Momin_3569
Contributor
Contributor

Set analysis

Sum(
Aggr(
If(
Disc_Term_Kroger > Disc_Term_HT
and [Standard Uterms] = Standard_Uterms_HT,
(Sum(
{<QuarterYear = {'Q3 2023', 'Q4 2023', 'Q1 2024', 'Q2 2024'}, "Payment or Credit" = {'Payment'}, [Outlier Dates] = {'Good Dates'}, SOURCE={'Harris Teeter'}>}
NetInvAmt1
) / 365) * (bestcdays - BestdaysHT),
0
),
Norm_Vend_name, [Standard Uterms]
)

 

 

there is a defualt bookmark of SOURCE='ED' used in the application , i dont the above formula's calculation to change because of that. The value is changing because of the filer, i tried using 1 and SOURCE= in set but nothing works

 

Labels (3)
1 Reply
Kushal_Chawda

@Momin_3569  try below

Sum({<SOURCE= >}
Aggr(
If(
Disc_Term_Kroger > Disc_Term_HT
and [Standard Uterms] = Standard_Uterms_HT,
(Sum(
{<QuarterYear = {'Q3 2023', 'Q4 2023', 'Q1 2024', 'Q2 2024'}, "Payment or Credit" = {'Payment'}, [Outlier Dates] = {'Good Dates'}, SOURCE={'Harris Teeter'}>}
NetInvAmt1
) / 365) * (bestcdays - BestdaysHT),
0
),
Norm_Vend_name, [Standard Uterms]
)