Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Fix a chart to YTD

Gurus,

Kindly assist, how do i fix a chart to only show YTD values and that it should not change despite other selections i.e. month?

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

With set analysis you can exclude specific fields from the expression

For instance sum({<Month>}amount) calculates the amount for all other selections but ignores a month selection.

You will see the same also writen as sum({<Month =>}amount). The = isn't necessary, the result is the same.

or

Help text:

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value. 

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

With set analysis you can exclude specific fields from the expression

For instance sum({<Month>}amount) calculates the amount for all other selections but ignores a month selection.

You will see the same also writen as sum({<Month =>}amount). The = isn't necessary, the result is the same.

or

Help text:

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value. 

View solution in original post

Highlighted
Creator
Creator