New to Qliksense - Script

[Anil_Babu_Samineni]

Hello Friends,

I just start fun with qliksense. Can anyone tell me I just download 3.1 SR3 and i've seen default application. Every script ended with below one

[autoCalendar]:

  DECLARE FIELD DEFINITION Tagged ('$date')

FIELDS

  Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

  Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged

('$quarter'),

  Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged

('$axis', '$yearquarter'),

  Month($1) AS [Month] Tagged ('$month'),

  Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth'),

  Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber'),

  Date(Floor($1)) AS [Date] Tagged ('$date');

DERIVE FIELDS FROM FIELDS "Month" USING [autoCalendar] ;

What is the usage of above one, Is this act as Calendar in qlikview / What? Can you describe more

And if some one have any qlik sense content for guide please share that content with me

[robert99]

hi

Very quickly looking at it. I don't think Canonical date is right for this (as you don't have one table with the right level of detail or grain)

First you must find a table with a grain fine enough; a table where each record only has one value of each date type associated.

Try instead (by using Data load editor)

Concatenating (stacking one on top of the other) the three data tables (Fixed data / elecData / Card Data)

after changing the three date names to Date (or CombinedDate etc)

eg FixedDate as Date

ElecDate as Date

StDate as Date

then only have a derived date as Date

eg

DERIVE FIELDS FROM FIELDS [Date] USING [autoCalendar] ;

[#3]

I very much appreciate this help. I just wanted to let you know that I won't be able to try it until tomorrow morning and will let you know how it goes.

Best wishes

Denis

Get Outlook for iOS<https://aka.ms/o0ukef>

[robert99]

add this after the auto-generated section.

It should work. Just filter by Day / Month / Year etc

But Data Manager is best for simple loads.Doing what you are doing. Its best to do everything with script using data Load editor. But for now this should work

//================================================================

DATANew:

Load

* ,

Fixed.Date AS DateC

RESIDENT Fixed_data ;

Concatenate (DATANew)

Load

* ,

ElecDate AS DateC

RESIDENT Elec_data ;

Concatenate (DATANew)

Load

* ,

St_Date AS DateC

RESIDENT Card_Data ;

drop table Elec_data , Fixed_data , Card_Data ;

Calendar:

load

DateC ,

Year (DateC) AS Year ,

Month (DateC) AS Month ,

Day(DateC) AS Day

resident DATANew ;

[#5]

Brilliant! Worked like a dream. I need to get serious about learning qliksense scripting.

Many thanks for your patience and help.

Denis