Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Sum total with conditional expression

Hi All

I'm very new with qlikview desktop personal, and keep trying to figure it out the conversion between RDBMS sql syntax to qlikview expression.

I

'm trying to create a selling history within several years 2009, 2010, 2011,

but with one condition

- a history selling of 2011, is a sum total sales recorded in 2008,

- a history selling of 2010, is a sum total sales recorded in 2007,

- a history selling of 2009, is a sum total sales recorded in 2006.

Any point regarding this will be more helpful on this.

Thank you

Best regards,

Irman

Tags (2)
1 Solution

Accepted Solutions
john_duffy
Contributor III

Re: Sum total with conditional expression

Hello.

I suggest using a mapping table to map the sum of the sales year to the history sales year.  See the attached example.

John.

2 Replies
john_duffy
Contributor III

Re: Sum total with conditional expression

Hello.

I suggest using a mapping table to map the sum of the sales year to the history sales year.  See the attached example.

John.

Not applicable

Re: Sum total with conditional expression

Hi John

Great sample!!! It gives me some good ideas how to fix similar problems

Thanks John

Regards,

Irman

Community Browser