topic Re: How can i view a month without ve a value in QlikView

How can i view a month without ve a value

Mon, 11 May 2015 05:38:46 GMT

Dear Friends

I wanna view months in horizontal manner. And I don't 've a column name like as month. There is any possibility to view months with the help of predefined methods. Pls Help me. If any possibility means please rply to me as a text or picture view don't send any qvw files bcoz I don't 've right to access those files....

Re: How can i view a month without ve a value

jonathandienst — Mon, 11 May 2015 05:43:47 GMT

Do you mean a list box? If so, uncheck single column in the Presentation tab and adjust the list box width and height to your preference.

Do you mean a pivot table? If you want the Month dimension to be arranged at the top of the pivot, hold down Ctrl and click the month column. Then drag the blue bar to the top until it turns from vertical to horizontal.

HTH

Jonathan

Re: How can i view a month without ve a value

Mon, 11 May 2015 05:47:18 GMT

Bro thank you for ur response.. I need a column month in my presentation. but I don't 've any value in my data source.

There is any possibility to get month value..........

Re: How can i view a month without ve a value

Mon, 11 May 2015 05:48:40 GMT

Even I don't 've any column like as "month".

Re: How can i view a month without ve a value

amit_saini — Mon, 11 May 2015 05:54:58 GMT

Abinesh,

Even if you are not having any month field in ur database , you can create it automatically in QlikView by using your date field.

Like below:

LET vMinDate = num(makedate(2010));

LET vMaxDate = num(today());

Datefield:

LOAD

$(vMinDate) + IterNo() -1 as Datefield

AUTOGENERATE (1)

WHILE $(vMinDate) + IterNo() -1 <= $(vMaxDate);

Calendar:

LOAD

Datefield as %Date,

date(Datefield) as Date,

year(Datefield) as Year,

month(Datefield) as Month,

day(Datefield) as Day,

week(Datefield) as Week,

weekday(Datefield) as Weekday

RESIDENT Datefield;

drop table Datefield;

Thanks,

Re: How can i view a month without ve a value

anbu1984 — Mon, 11 May 2015 06:20:06 GMT

Do you have any date field in your input?

Re: How can i view a month without ve a value

Mon, 11 May 2015 06:21:33 GMT

No anbu

Re: How can i view a month without ve a value

anbu1984 — Mon, 11 May 2015 06:27:45 GMT

Can you post sample input and expected output. How is months related to your input?

Re: How can i view a month without ve a value

jonathandienst — Mon, 11 May 2015 06:28:17 GMT

If you have no month field and no date field, how do you propose to populate the month?

Re: How can i view a month without ve a value

Mon, 11 May 2015 06:31:24 GMT

That's my question "jonathan". In qlik view is it 've any predefined methods are packages.....?

To solve this problem...?

Re: How can i view a month without ve a value

Mon, 11 May 2015 06:39:57 GMT

Bro ur code is working but it not automatically associate with my date field in a data source

Re: How can i view a month without ve a value

amit_saini — Mon, 11 May 2015 06:51:02 GMT

Yes for sure this will not work without any date field in your database.

Thanks,

Re: How can i view a month without ve a value

Mon, 11 May 2015 07:32:18 GMT

But I already 've some data like date.... in my data source jst I wanna get a month from that date column..

that's I need.....

Re: How can i view a month without ve a value

anbu1984 — Mon, 11 May 2015 08:43:35 GMT

You replied above that you don't have a date field in your input.

If you a have Date field, then use Month() to get the month from date.

Re: How can i view a month without ve a value

emili_bonilla — Mon, 11 May 2015 08:52:22 GMT

Abinesh,

To link your data to the master calendar that Anbu proposed, please make sure that your date field has exactly the same name as the field in the calendar. Us "as" to rename the field from the calendar.

Regards

Re: How can i view a month without ve a value

amit_saini — Mon, 11 May 2015 09:43:56 GMT

But that what I suggested you in my first reply.

Thanks,