I want to insert some calculated values inside a inline table's column.

[gp101198]

Can someone please check this one and give some solution. Actually I wanted to create an inline table in Qlik Sense query editor as shown in excel Screenshot. I am writing function in query editor but it is not showing value instead it is showing the function string only.

Pls find the SS for reference.

Above is the excel ss which is the desired result.

This is what I am using in editor.

This is what I am getting in front-end. Pls help Team its important.

Query for your reference:

Tab_Date_Range:
Load * Inline
[Type, Date_Range, Start Date, End Date
MON, 6 Months ,(MonthsStart(today(),-6)) ,(MonthsStart(today(),0))
MON,12 Months, (MonthsStart(today(),-12)), (MonthsStart(today(),0))
MON, 18 Months, (MonthsStart(today(),-18)), (MonthsStart(today(),0))
MON, 24 Months, (MonthsStart(today(),24)), (MonthsStart(today(),0))
QTR, 4 Quarters, (MonthsStart(today(),-12)), (MonthsStart(today(),0))
QTR, 8 Quarters,(MonthsStart(today(),24)) , (MonthsStart(today(),0))
ANN, 1 Year,(MonthStart(YearEnd(today()),-12)) ,(MonthStart(YearEnd(today())))
ANN, 2 Year,(MonthStart(YearEnd(today()),-24)),(MonthStart(YearEnd(today())))
ANN, 3 Year,(MonthStart(YearEnd(today()),-36)) ,(MonthStart(YearEnd(today())))
ANN, 4 Year,(MonthStart(YearEnd(today()),-48)) ,(MonthStart(YearEnd(today())))
ANN, 5 Year,(MonthStart(YearEnd(today()),-60)) ,(MonthStart(YearEnd(today())))
];

Regards

Gagan

[rwunderlich]

A couple of items:

1. Because your expressions contain comma, and comma is the default inline delimiter, you will need to include your values in quotes. 

2. Use Evaluate() to convert your expressions to values. 

3. I think you meant "MonthStart", not "MonthsStart". 

Working script:

Tab_Date_Range:
Load
  Type,
  Date_Range,
  Evaluate([Start Date]) as [Start Date],
  Evaluate([End Date]) as [End Date]
Inline
[Type, Date_Range, Start Date, End Date
MON, 6 Months ,"(MonthStart(today(),-6))", "(MonthStart(today(),0))"
MON,12 Months, "(MonthStart(today(),-12))", "(MonthStart(today(),0))"
MON, 18 Months, "(MonthStart(today(),-18))", "(MonthStart(today(),0))"
MON, 24 Months, "(MonthStart(today(),24))", "(MonthStart(today(),0))"
QTR, 4 Quarters, "(MonthStart(today(),-12))", "(MonthStart(today(),0))"
QTR, 8 Quarters, "(MonthStart(today(),24))" , "(MonthStart(today(),0))"
ANN, 1 Year,"(MonthStart(YearEnd(today()),-12))", "(MonthStart(YearEnd(today())))"
ANN, 2 Year,"(MonthStart(YearEnd(today()),-24))", "(MonthStart(YearEnd(today())))"
ANN, 3 Year,"(MonthStart(YearEnd(today()),-36))", "(MonthStart(YearEnd(today())))"
ANN, 4 Year,"(MonthStart(YearEnd(today()),-48))", "(MonthStart(YearEnd(today())))"
ANN, 5 Year,"(MonthStart(YearEnd(today()),-60))", "(MonthStart(YearEnd(today())))"
];  

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Channa]

Actually you expression is not getting evaluated

you need to write preceding load