Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
israrkhan
Specialist II
Specialist II

Multiple Dates

Hi Community,

i have 2 simplw question please answer:

1) I Have To Develope a Balance Score Card, There Are 13 KPI in Different Excel Files and qvd's.

Each KPI Have its own Date In Different format then others, so is it possible to create one calendar to analuse all KPI with one date, OR

How to handle with all dates.. (Some KPI are for two year eg 2011 and 2012, and some are sine 2000, and some since 2005)

sp shall i join all table with Date or how to deal.

2) how to change Month format January to Jan, in Number tabe i am changing to MMM , But its not changing the format.

Suggestion Please.

Kind Regards

Khan

1 Reply
er_mohit
Master II
Master II

You have to make master calender then using floor function with your different date you can link with this calender.

make sure that the date format for all datefield is same .Hope it helps You

you could join also for doing that but it quite complicated table because your all Fact tables are attached in one table

Hope it helps you