Solved: Re: Total Sales - Qlik Community

Report Inappropriate Content · ‎2011-05-23

Hi all,

I have a straight displaying a number of expressions, but I need to display the total historical sales as an expression that is not affected by any selections, If I use set analysis ({1< etc is expands the whole table and will not therefore allow any selections to reduce the data to an indiviidual product or item.

Can anyine tell me how I achieve this?

The Straight table has 3 dimensions, Item Short Name, Supplier & Platform.

=sum({<[SOP Type]={'Invoice'}>} Quantity) - is my current solution

I had thought aout displying this info as a calculated dimension? Is this possible?

Regards

Richard

yasus · ‎2011-05-23

Hi Rich,

you can use the "Ignore-Selection-Modifier", in order to show allways the total sales.

sum({<
          [SOP Type]={'Invoice'}, 
          %Key_Calendar=,
          Month=, 
          CalendarYear=
     >}  
[Extended Price])

View solution in original post

kaushiknsolanki · ‎2011-05-23

Hi,

Can you please upload the QVW for more reference and understanding of your requirement.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-23

As requested please find attached qvw file.

Many Thanks

Rich

yasus · ‎2011-05-23

Hi Rich,

you can use the "Ignore-Selection-Modifier", in order to show allways the total sales.

sum({<
          [SOP Type]={'Invoice'}, 
          %Key_Calendar=,
          Month=, 
          CalendarYear=
     >}  
[Extended Price])

Report Inappropriate Content · ‎2011-05-23

Gregor,

That seems to have done the trick,

Thankyou very much.

Richard