Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Valued Contributor 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


1 Reply
Honored Contributor II

Re: Multiple Dates

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

Community Browser