Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Total Sales

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: Total Sales

As requested please find attached qvw file.

Many Thanks

Rich

Highlighted
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