topic Re: Dimension and Fact Information in Chart in QlikView

Dimension and Fact Information in Chart

SK28 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dimension and Fact Information in Chart

Anonymous — Sun, 02 Apr 2017 10:14:53 GMT

Like this??

And limit the dimension as shown

Re: Dimension and Fact Information in Chart

SK28 — Mon, 03 Apr 2017 17:10:07 GMT

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

Re: Dimension and Fact Information in Chart

Anonymous — Tue, 04 Apr 2017 04:01:15 GMT

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

Re: Dimension and Fact Information in Chart

SK28 — Tue, 04 Apr 2017 14:44:03 GMT

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