Performance Issue

[#1]

Hi Guys

I am facing some performance issues in my qlikview application. Given below is my tables and size of data and expression that I am using.

I have one table Details (4 Lakh rows) each row contains a project_id, a report_id and no of dates confirming,analyzing,........,verifying (15 dates).

In my application there are three list boxes.

Fist list box contains the project names  and all ids of Details table are realted to one of projects from here

(ii) Second List Box is for start date

(iii) Third list box is for end date

I created a bar chart where i want to count the ids based on dates. There are three type of count type1,type2,type3 and each type have different conditions on dates and i want this dates dynamic.

So i created variables and put the logic of dates like how many possible of selection of dates from UI for start/end dates and using that variable in my expression ib Bar graph, But this is badly impacting the performance and it takes lot of time to appear tha bar graph.

Kindly suggest me most favorable way of where to use my dates logic that i am currently using in variables or suggest some best optimize solutions. Kindly help its very urgent

[#2]

Attach a sample Application of your purpose so it will be easy for you and for us to help you