Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I have created Qlik Sense App. I am using straight table and some filters to see data. In my straight table i have dimensions , measures and date field called Maturity Date.
I want to create filed name called "Days to Maturity" (integer number 1,2 ... to 30 ).
When user selects any value in "Days to Maturity" (integer number 1,2 ... to 30 ). the data in straight table should change.
i.e data in straight table should show between maturity date + "Days to Maturity"
e.g If Maturity Date is 8/14/2018
Days to Maturity = 5
Straight table should show data of dates 8/14/2018,8/15/2018 , 8/16/2018 ,8/15/2018 ,8/16/2018.
any suggestions how to achieve this?
thanks in advance.
Is it possible to create flag in the script?
Tomasz
What you need is The As-Of Table
This is my script
Data:
LOAD
"ACCOUNT ID",
"ACCOUNT NAME", // Report Filter
"BUSINESS UNIT", // Report Filter
"MATURITY DATE",
"SECURITY ID",
"INSTRUMENT ID",
"SECUIRTY NAME",
InstrumentTypeTier2,
"Rate",
Quantity,
"MARKET VALUE",
COST,
"ACCRUED INTEREST",
PERCENT_of_PORTFOLIO,
BusinessDate, // Report Filter
ExpiryDate
FROM [lib://$(QVDPath)/Maturity_QVD.qvd]
(qvd);
In report I am using following filters ->>>>
"ACCOUNT NAME", // Report Filter
"BUSINESS UNIT", // Report Filter
BusinessDate, // Report Filter
Days To Maturity // Integer Value
Straight table is showing following fields, where maturity date should changes as per Days to maturity and Business Date Selection ->>>>
"ACCOUNT ID",
"MATURITY DATE",
"SECURITY ID",
"INSTRUMENT ID",
"SECUIRTY NAME",
InstrumentTypeTier2,
"Rate",
Quantity,
"MARKET VALUE",
COST,
"ACCRUED INTEREST",
PERCENT_of_PORTFOLIO,
Hi,
I think the approach is not the best, but not sure I understand what you want to do.
Why don't you just :
- Create a field [End Date], which is [Maturity Date] + [Days to Maturity]
and then, in you straight table, add columns : [Maturity Date], [Days to Maturity] and [End Date], and allow users to filter on theses dates.
Hope it helps anyway,
Good luck,
Marina