Date Range

[#1]

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..

[Gysbert_Wassenaar]

See this tutorial