Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

How can we show the values in Vertical in Above chart

Hi all

Untitled.png

Thanks

10 Replies
veidlburkhard
Creator III
Creator III

In properties, presentation mark 'vertical'

Vertical.jpg

Regards

Burkhard

sunny_talwar

On the Presentation tab - > check Vertical

Capture.PNG

I believe this is what you are looking for.

Best,

Sunny

Anonymous
Not applicable

Capture.PNG

madhubabum
Creator
Creator
Author

Thanks Vinay Bangari

SatyaPaleti
Creator III
Creator III

Hi,

On Properties --> Presentation --> There is a option Vertical --> Check it

Thank you,

Satya Paleti

madhubabum
Creator
Creator
Author

Hi Kush141087

Thanks for you reply

LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD'));    //FY13 and onward

LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));   

tmp_CALENDAR:

LOAD

    Date($(vMinDate) + RowNo() - 1) AS tmp_Date

AUTOGENERATE

    $(vMaxDate) - $(vMinDate) + 1;

   

Set vFM = 10; // First month of fiscal year

MASTER_CALENDAR:

LOAD

    tmp_Date AS %ORDER_DATE_KEY,                   

    Week(tmp_Date) AS Week

RESIDENT tmp_CALENDAR

ORDER BY tmp_Date ASC;

DROP TABLE tmp_CALENDAR;   

madhubabum
Creator
Creator
Author

LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD'));    //FY13 and onward

LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));   

tmp_CALENDAR:

LOAD

    Date($(vMinDate) + RowNo() - 1) AS tmp_Date

AUTOGENERATE

    $(vMaxDate) - $(vMinDate) + 1;

   

Set vFM = 10; // First month of fiscal year

MASTER_CALENDAR:

LOAD

    tmp_Date AS %ORDER_DATE_KEY,                   

    Week(tmp_Date) AS Week

RESIDENT tmp_CALENDAR

ORDER BY tmp_Date ASC;

DROP TABLE tmp_CALENDAR;   

madhubabum
Creator
Creator
Author

LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD'));    //FY13 and onward

LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));   

tmp_CALENDAR:

LOAD

    Date($(vMinDate) + RowNo() - 1) AS tmp_Date

AUTOGENERATE

    $(vMaxDate) - $(vMinDate) + 1;

   

Set vFM = 10; // First month of fiscal year

MASTER_CALENDAR:

LOAD

    tmp_Date AS %ORDER_DATE_KEY,                   

    Week(tmp_Date) AS Week

RESIDENT tmp_CALENDAR

ORDER BY tmp_Date ASC;

DROP TABLE tmp_CALENDAR;   

madhubabum
Creator
Creator
Author

Hi

thanks to reply..

Please find my following code

LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD'));    //FY13 and onward

LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));   

tmp_CALENDAR:

LOAD

    Date($(vMinDate) + RowNo() - 1) AS tmp_Date

AUTOGENERATE

    $(vMaxDate) - $(vMinDate) + 1;

   

Set vFM = 10; // First month of fiscal year

MASTER_CALENDAR:

LOAD

    tmp_Date AS %ORDER_DATE_KEY,                   

    Week(tmp_Date) AS Week

RESIDENT tmp_CALENDAR

ORDER BY tmp_Date ASC;

DROP TABLE tmp_CALENDAR;