Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

keep a time period as whole

Dear All,

I am trying to prepare a very basic set analysis and it seems to work very well so far.

It includes all typical values as turnover, products, areas, etc for all 12 months and for different years.

Now I need to add a matrix which has to represent the trend of sold quantities from jan to dec for all 5 years.

It means I need to always show all 5 years and all 12 months for each year. (See below example)

yearmonthsold product A
2010Jan150€
2010Feb162€
.........
2011Jan148€
2011Feb153€
.........
2014Sep163€
2014Oct154€
2014Nov142€
2014Dec162€

It has to depend only by the selected product (or products if I select more than one). I am not able to use the set analysis since it results affected by the selected period.

Which is the suggest to have this matrix and relevant graph shown on QV independently by the selected year/month?

Thank you in advance

Massimo

1 Solution

Accepted Solutions
Gysbert_Wassenaar

This expression would ignore selections in the Year and Month field:

sum({<Year=,Month=>}SalesAmount)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

This expression would ignore selections in the Year and Month field:

sum({<Year=,Month=>}SalesAmount)


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert,

it was easier than what I thought.

It works properly.