Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Total Sales

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

1 Solution

Accepted Solutions
yasus
New Contributor III

Re: Total Sales

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

4 Replies

Total Sales

Hi,

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

Regards,

Kaushik Solanki

Not applicable

Re: Total Sales

As requested please find attached qvw file.

Many Thanks

Rich

yasus
New Contributor III

Re: Total Sales

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

Not applicable

Re: Total Sales

Gregor,

That seems to have done the trick,

Thankyou very much.

Richard