What is the meaning of this syntaxes?

[arethaking]

Hi All,

What are the meaning of these two syntaxes?

Thanks in advance.

date(floor(monthend(round(date#('01'&left(@1, 3) &'20' & right(@1,2),'DDMMMYYYY')))),'DD/MM/YYYY') as SalesDate,

SET variable1=Time(floor(Frac($1),1/24/60),'h:mm');

[Anil_Babu_Samineni]

@1 is the field i am assuming. Can you send few values. It will create / makes the Dates and then create round for that date and using the MonthEnd for that specific date month then again floor for that. And it retrieve dates finally.

Think same way from your end and help us to reply

And, Variable it create as =Time(floor(Frac(Now()),1/24/60),'h:mm') // Check from your end

[Peter_Cammaert]

The first (column) definition will create a correct QlikView date value from a period string in the first column of your data source. This period string is probably formatted like MMMYYYY, like 0012014 for the first booking period of 2014.

The second example is a paremeterised variable function taking a single parameter that will create a time spec based on the input parameter. But I'm not sure that the last one will ever work... It does work.

[Peter_Cammaert]

The second expression contains an explicit rounding to the nearest minute, using floor(value, nearest rounding value)

[arethaking]

Hi All,

I did not understand @1  in script expression, $1 in variable statement.

Please explain.

Thank you.

[Anil_Babu_Samineni]

Read for $1 Variables with Parameters

@1 consider as default field name if there is no field names on your source table or loaded from community directly

You can change if you want

LOAD

  @1 as [STG1_Inlet_Steam_Flow],

  @2 as [STG1_kW],

  @3 as [STG1_Steam_Press],

  @4 as [STG1_Steam_Temp],

   etc...