Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Help

HI,

i ahve one requirement ,in that i have field WEEK.i m showing week wise trend.

if i select january it is showing Week 1 to week5 its fine.if i select two months i want to show two months weeks i.e 9 or 10 months

is it posible to show ? if yes,how?

Here i m sharing sample file too.Give me some valid solutions.

Its Urgent>>>>>>>>>>>>>>>>>>>>>>>>.

Regards,

Nagarjuna

4 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Hi Narjuna Kothmandi,

I will suggest you make a Master Calendar to link DOJ field.

have a look at tutorial link :

QlikView How To (or Tips & Tricks) Application by Lee Matthews

  http://community.qlik.com/docs/DOC-5486

mrossoit
Creator II
Creator II

Hi,

not sure to unerstand your request.

Check out the sample

Regards

MR

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II
Author

Hi,

Exactly its correct.But Weeks are not sorted properly,Can you cheak that?

Regards,

Nagarjuna

mrossoit
Creator II
Creator II

Add to Emp table a field like

right('0' & num(Month), 2) & ' - ' & Week as MM_Week

and use it as dimension of your chart

Regards,

MR