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

values only in previous year don't show with set analysis and straight table

I need to have a stright table with accounts in dimensions and sum(values) from both current and previous year.

But, for different accounts i must set a diferent sum criteria:

1* only sums type 2 and 3

2* sums types 0, 2 and 3

everything works ok if the accounts have values in both the current and previous year...

but i.e. account 22 doens't have values for 2012... so it doens't show the 1900 value!

Any help?

1 Solution

Accepted Solutions
Not applicable
Author

solved with help from another post:

sum( {< #acc={"1*"}, regTy={2,3} >} regV )

+

sum( {< #acc={"2*"}, regTy={0,2,3} >} regV )

View solution in original post

1 Reply
Not applicable
Author

solved with help from another post:

sum( {< #acc={"1*"}, regTy={2,3} >} regV )

+

sum( {< #acc={"2*"}, regTy={0,2,3} >} regV )