Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

skkrishna
New Contributor III

Dimension and Fact Information in Chart

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.


qlik.PNG

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



Tags (2)
4 Replies
laddu_927
Valued Contributor

Re: Dimension and Fact Information in Chart

Like this??

And limit the dimension as shown

Capture.PNG

skkrishna
New Contributor III

Re: Dimension and Fact Information in Chart

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

laddu_927
Valued Contributor

Re: Dimension and Fact Information in Chart

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

skkrishna
New Contributor III

Re: Dimension and Fact Information in Chart

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