Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ibradly
Contributor III
Contributor III

Ignore dimension in table while using set analysis

I am trying to get the total sales for a single day.

I want to ignore all the dimensions that is currently in the table and get total sales for the day the email was sent out.

Send DateGA CampaignMessage IDMessage TypeEmail SubjectSend DefinitionEmail SalesTotal Sales
11/10/2019Online21356Job SendGet 25% offN/A210,000600,000

 

As you can see from above the "Email Sales" is giving me Sales for the "online" campaign for the whole week when the week filter is applied. "Total Sales" needs to have all sales that got recorded on the 10th regardless if it was a campaign sale or an organic sale. 

I am not able to get the total sale for that  given day. I have looked on the community forums and haven't found a solution yet. 

Can someone please help me? I am roughly new to Qlik. 

Thanks.

Labels (2)
1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

HI there!

I'm not sure what's the connection with Set Analysis, but I think what you need is to use the TOTAL qualifier in your expression. Something like this should work:

sum(TOTAL <Date> Sales)

Cheers!

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

HI there!

I'm not sure what's the connection with Set Analysis, but I think what you need is to use the TOTAL qualifier in your expression. Something like this should work:

sum(TOTAL <Date> Sales)

Cheers!

ibradly
Contributor III
Contributor III
Author

Thank you! It worked!