Hi,
As i am new in Qlick View Application, Can anybody tell me how to get the date accordningly by inputing the dates in two fields by user.
I am using Sql tabels to get the data, and for output using the Chart(pivot)
Ex:
Table in sql is Sales invoice line
Fields : Item Name, Party Name, Order Date, Quantity
used query is :-
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=mukesh;Initial Catalog=BCPL_LIVE;Data Source=192.168.1.252;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MUKESH-PC;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is EKMdCXFNELYAUZIGRJFB);
SQL SELECT "Item Code", "Party Name", "Order Date", "Quantity"
FROM "BCPL_LIVE".dbo."Bodycare Creations$Sales Invoice Line"
After that i used chart for the date...now how can i get the data between the user specific date range
Thanks in Advance..
