Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Aggregate from temporary table to dimension

Hi all

I have a table with Customer ID, First Order Date and another table with Date, Customer ID and Dispatch

I select a period of Dates and I create vStartDateTY=min(Date) and vEndDateTY=max(Date)

I want to assign to each customer the label of "new" if her first order date is between vStartDateTY and vEndDateTY or "existing" otherwise.

Then I want to create a table on the sheet that aggregates dispatches per "new" and "existing". What do I put as dimension? I know that Dispatch should me the measure.

Can you help?

George

0 Replies