How can i view a month without ve a value

[#1]

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....

[jonathandienst]

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

[#3]

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..........

[#4]

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

[amit_saini]

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,

AS

[anbu1984]

Do you have any date field in your input?

[#7]

No anbu

[anbu1984]

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

[jonathandienst]

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

[#10]

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

To solve this problem...?