Dimension and Fact Information in Chart

[SK28]

Hi,

was wondering if anyone would be able to help me,

Thanks in Advance.

I'm Having Two Columns, Show a Bar Chart Based on those two columns.

It Has only 12 Weeks of Data.(if the New Week Gets Added, lowest old week data will be automatically removed)

Sample Data:

UNIT_NUMBER         DATE(Field)

1234                           3/01/2017

1234                           3/03/2017

1234                           3/04/2017

12345                          3/01/2017

12345                          3/05/2017

123456                         3/09/2017

123457                         3/09/2017

123458                         3/09/2017

So Based on the above requirement,

I want a bar chart.

I dont know which variable to take X and Y Axis in Qlikview.

attached is the screen shot of Expected Output.

the Issue is if I Consider Week here..

Example:

                                              Result      BUT REQUIRED RESULT

WeekStart(3/01/2017) =             9                           1

Hence it will go into '3-12 Week'

But here the Unit has came for the 1st time in March.

So its should fall in 'Week 1' Bucket.

for Example if it Comes in Week 1 and Week 2 then the count should be Show in both Week 1 and Week 2.

if it comes in Week 3or4or5.... then it show in 3-12 as well...!!

SO BASICALLY MY REQUIREMENT IS HOW MANY UNITS HAS CAME FOR THE 1ST TIME - SHOULD SHOW IN WEEK1.

SIMILARLY FOR OTHER CATEGORY Week 2 and week 3-12

[Anonymous]

Like this??

And limit the dimension as shown

[SK28]

Thanks for the Answer.

But the Issue is if I Consider Week here..

Example:

                                              Result      BUT EXPECTED RESULT

WeekStart(3/01/2017) =             9                           1

Hence it will go into '3-12 Week'

But here the Unit has came for the 1st time in March.

So its should come in 'Week 1' List.

for Example if it Comes in Week 1 and Week 2 then the count should be Show in both Week 1 and Week 2.

if it comes in Week 3 then it show in 3-12 as well...!!

SO BASICALLY MY REQUIREMENT IS HOW MANY UNITS HAS CAME FOR THE 1ST TIME - SHOULD SHOW IN WEEK1.

SIMILARLY FOR OTHER CATEGORY

[Anonymous]

How are the Weeks calculated?? Does they start from March 1st week??

[SK28]

from Jan 1st week till March 31st.

When April 1st Week Data gets Appended. Then 1st week of Jan Data will be removed. and So on