Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Actually you expression is not getting evaluated
you need to write preceding load