1 Reply Latest reply: Jul 25, 2017 5:07 AM by Jose Miguel Vilaplana Pascual RSS

    How can I show today sales by specific business unit?

    jacob so

      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.