Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Set analysis

I want to achieve this using set analysis in qlik sense

I want to sum my Quantity

If [Table Source] = 'WHUIL200' then [INDT] = [GMT]

where INDT and GMT are two date fields and [GMT] = last month end date.

2 Replies
Anil_Babu_Samineni

For me this is similar to this

Set Analysis - Qlik Community - 1854127

Perhaps this?

Sum({<[Table Source]={'WHUIL200'}, INDT={"=INDT=GMT"}>} Quantity)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
risabhroy_03
Partner - Creator II
Partner - Creator II
Author

I am using this

if([Table Source]='WHUIL200',Sum({$<[Invoice_Date_GMT]={"$(vLastmonthdate)"}>} Quantity))

I want to sum my quantity when my [Invoice_Date_GMT] = my variable vLastmonthdate but it shows 0.

Please help