topic Re: Total Sales in QlikView

Total Sales

Mon, 23 May 2011 11:38:25 GMT

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

Total Sales

kaushiknsolanki — Mon, 23 May 2011 11:44:03 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: Total Sales

Mon, 23 May 2011 11:48:22 GMT

As requested please find attached qvw file.

Many Thanks

Rich

Re: Total Sales

yasus — Mon, 23 May 2011 13:06:53 GMT

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])

Re: Total Sales

Mon, 23 May 2011 13:23:41 GMT

Gregor,

That seems to have done the trick,

Thankyou very much.

Richard