Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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!
Thank you! It worked!