keep a time period as whole

Mon, 16 Mar 2015 15:45:35 GMT

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)

year	month	sold product A
2010	Jan	150€
2010	Feb	162€
...	...	...
2011	Jan	148€
2011	Feb	153€
...	...	...
2014	Sep	163€
2014	Oct	154€
2014	Nov	142€
2014	Dec	162€

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

Re: keep a time period as whole

Gysbert_Wassenaar — Tue, 17 Mar 2015 10:39:04 GMT

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

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

Re: keep a time period as whole

Tue, 17 Mar 2015 11:01:29 GMT

Thanks Gysbert,

it was easier than what I thought.

It works properly.

topic Re: keep a time period as whole in Qlik Learning Discussions

keep a time period as whole

Re: keep a time period as whole

Re: keep a time period as whole