Discussion board where members can get started with QlikView.
I have a query as below:
'Future' as Aging_Descr,
'STD' as Aging_Id
from ps_item a, ps_item_activity b,
select (Date $(vCalendar) - a.accounting_dt) days
from ps_item a
where a.item =b.item
and days < 0
'Current' as Aging_Descr,
where a.item = b.item
and (days <= 30 and days>=0)
Now, I want that user should enter a date(vCalendar) and based on that date qlikview will show the o/p.
But as 'Date' is a qlikview function so it's not converting this number into date type.
So how can i use this variable and convert it into date type.
The query you presented is a SQL query.
As you noted you cannot use QlikView functions in a SQL query, you must use the syntax of the SQL dialect your using.
I suggest you search the web for Date functions for the database you are using.
that query is in SQL.you can use function of SQL in qlikview but not qlikview function in SQL.