Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Sales - StartDate & EndDate two years comparison

Hi Guys,

I'm new at Qlikview and i  really like to have the possiblities to use the comparison analysis technics.

You can see the issue underneath. i would like to see data in the second and third column which based on   two comparisons from the startdate & enddate.

How can i have data on the second and third column?

Thank you and hope to see your reactions soon.

Greets,

Rega

2 Replies
Highlighted

Re: Sales - StartDate & EndDate two years comparison

What is your current expression for Sales TY?

Highlighted
Not applicable

Re: Sales  - StartDate & EndDate two years comparison

sum ({$<Year={$(=Only(Year))}>}TransactionQuantity*SalesPrice)/1000