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: 
Anonymous
Not applicable

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
Master II
Master II

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

Anonymous
Not applicable
Author

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
Specialist III
Specialist III

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.

Anonymous
Not applicable
Author

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?