Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am beginner to qlik view . I am facing problem in generating a repor.
1. i wanted to display two slider contol so as to select to date and from date.
2. based on this selection i have to display the data in the table view.
Now how should i do that . How to write a script to get the date range in a variable . and how should i have the where condition in the table so as to display the data based on the selected dates.
sql query is something like this
select appt_count from
appt'
where clientid=03
'and to_char(crdt, 'MM/DD/YYYY')= to_char(sysdate , 'MM/DD/YYYY')"
Hi,
could you please show the table-scheme you are using?
I mean:
The fact table, where you want to get the data from and the calendar table and the relations between those tables.
Actually, dependent from your application design you don't need to make any further selections or scriptings.
Example: sum(revenue) may always show the summation of the time-range you selected, if the date-fields are linked to the table where the revenue values are.
HTH
Thanks Lacker
I HAVE A TABLE REPORT WHICH HAVE SEVERAL COLUMN. I HAVE TO GET DATA OF THIS REPORT BASED ON THE SELECTED DATED. THIS SELECTED DATE WILL BE THE CREATED DATE COLUMN OF THE REPORT TABLE. sO WE HAVE WHERE CONDITION IN WHICH WE WILL GIVE THE DATE RANGE.
Is this clear or i need to put some more information.