Discussion board where members can get started with QlikView.
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)
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..
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
And limit the dimension as shown
Thanks for the Answer.
But the Issue is if I Consider Week here..
Result BUT EXPECTED RESULT
So its should come in 'Week 1' List.
if it comes in Week 3 then it show in 3-12 as well...!!
SIMILARLY FOR OTHER CATEGORY
How are the Weeks calculated?? Does they start from March 1st week??
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