Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to ignore selections for a dimension in a straight table?

I've got a straight table with Year as dimension and Sum(Sales) as expression (and as a mini-chart). I want the table to show the sum of sales and mini-chart by months for all years, which would be the same as making no selections at all in the Year-listbox. Problem is that every time a user choose a Year the straight table updates to the choosen years. Though I whould like the straight table to act somewhat like a summary for all years.

Any ideas?

best regards.

1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

How to ignore selections for a dimension in a straight table?

Hi, You can use:

Sum({1} Sales) - If you want to ignore any selections

You can use:

Sum({<Year = >} Sales)  - If you want to ignore selections in the field Year

You can include other fields you want to ignore:

Sum({<Year = , SalesPerson = >} Sales) - it ignores selections in year and SalesPerson

Hope this helps,

Erich

3 Replies
john_duffy
Contributor III

How to ignore selections for a dimension in a straight table?

Hello.

Try using set analysis - Sum({1} Sales).  This will disregard the selection in Year.

erich_shiino
Honored Contributor

How to ignore selections for a dimension in a straight table?

Hi, You can use:

Sum({1} Sales) - If you want to ignore any selections

You can use:

Sum({<Year = >} Sales)  - If you want to ignore selections in the field Year

You can include other fields you want to ignore:

Sum({<Year = , SalesPerson = >} Sales) - it ignores selections in year and SalesPerson

Hope this helps,

Erich

Not applicable

How to ignore selections for a dimension in a straight table?

Thanks guys, works perfectly

Community Browser