topic Re: Help in QlikView

Help

nagarjuna_kotha — Tue, 12 May 2015 07:43:35 GMT

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

jpenuliar — Tue, 12 May 2015 07:55:27 GMT

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

mrossoit — Tue, 12 May 2015 08:07:31 GMT

Hi,

not sure to unerstand your request.

Check out the sample

Regards

nagarjuna_kotha — Tue, 12 May 2015 08:32:54 GMT

Hi,

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

Regards,

Nagarjuna

mrossoit — Tue, 12 May 2015 09:02:31 GMT

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,