Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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