Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How can I show today sales by specific business unit?

Hi, I'm very new to Qlik sense, I am trying to create a KPI which shows today Sales while filtering specific BU.

I've tried to search the web and what I get now is the first part with below expression:

=sum({<[Sales Date] = {'$(=Date(today()))'} >} [Total Net Sales])

However I am quite stuck in filtering it by another dimension "BU".

Can anyone please help?

Thanks in advance.

1 Reply
Highlighted
jmvilaplanap
Valued Contributor

Re: How can I show today sales by specific business unit?

Hi

Just add the new filter in the Set Analysis

=sum({<[Sales Date] = {'$(=Date(today()))'}, BU={'Other Value'} >} [Total Net Sales])


Regards