Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

maxicarena
Contributor

Load a field that is assigned as month and another as year

Hello community !, I do not know how to solve this problem ...

I have a table with 2 fields, 1º column is the Name of the branch and the other indicates if they met OBJETIVE, this I have a month close, so I want add a third column but cover the entire month, for example 12/2017 (December 2017). How can I do to solve it?


To clarify I have other records with the field DATE and that is configured in the script with the CALENDAR function.

    

NAME BRANCHOBJETIVEMONTH YEARorMONTH
CórdobaYes12/2017 12
CatamarcaNo12/2017 12
La RiojaNo12/2017 12
Santa FeYes12/2017 12

I appreciate much your time and attention.

4 Replies
devarasu07
Honored Contributor II

Re: Load a field that is assigned as month and another as year

Hi,

try to add Date field instead of monthYear or Month (because these all can extracted form Date).

Fact:

NAME BRANCH,OBJETIVE,DATE

Calendar: using the master calendar script you can do periodically report (like yearly,weekly, monthly etc)

Year, Month, Week, DATE

ref: master calendar script

Master Calendar Generation Script

https://community.qlikview.com/thread/48693

maxicarena
Contributor

Re: Load a field that is assigned as month and another as year

Hi Devarasu R, thanks for your answer,

What happens is that I already tried to add the Date field, but I have to place for example 01/11/2017 (DD, MM, YYY), then the values ​​that I completed in the same row of the excel file (for example) only go to show on 01/11/2017 and not during the days 02/11/2017, 03/11/2017, ETC.

JustinDallas
Valued Contributor

Re: Load a field that is assigned as month and another as year

You will have to generate the dates in between the beginning and the ending of the month, assuming I'm reading your question correctly.

Tienes que generar los dias entre la comienza y el fin del mes.  Deberias a usar un calendario maestro.

maxicarena
Contributor

Re: Load a field that is assigned as month and another as year

Dastin, If I do not understand wrong, tells me that I have to do something like this:

NAME BRANCHOBJETIVEDATE STARTDATE END
CórdobaYes01/12/201731/12/2017

How do I relate it to the master calendar?

Community Browser