Ignore dimension in table while using set analysis

[ibradly]

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 Date	GA Campaign	Message ID	Message Type	Email Subject	Send Definition	Email Sales	Total Sales
11/10/2019	Online	21356	Job Send	Get 25% off	N/A	210,000	600,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.

[Oleg_Troyansky · Accepted solution]

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]

Thank you! It worked!