Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
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

Highlighted
Creator
Creator

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.

Highlighted
Specialist II
Specialist II

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.

Highlighted
Creator
Creator

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?