8 Replies Latest reply: Nov 30, 2017 9:06 AM by Adam Hughes RSS

    Qlik Sense Pivot Table Set Analysis Help

    Adam Hughes

      Hello,

       

      I have an expression that works perfectly fine when selecting one dimension value as I am using the ONLY function like so:

      Sum({<[Sales Invoice Date]={">=$(=max(Drop_Date)) <=$(=vDropDateMonthEnd)"},Product_Brochure_Code={$(=only([Brochure_Code]))}>}[Sales Total (GBP)])

       

      However I now need to put this data into a pivot table so that I can compare [Brochure_Code]'s against each other, like in the first attached image, previously done manually in Excel.

       

      Is it possible to use a pivot tables column/dimension value inside of the set analysis expression?

      Current Qlik pivot layout in second attachment.

       

      Any help is appreciated.

       

      Thanks

      Adam