Performance Issue

Mon, 24 Sep 2012 05:34:03 GMT

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

Re: Performance Issue

Mon, 03 Dec 2012 05:49:17 GMT

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

topic Re: Performance Issue in QlikView

Performance Issue

Re: Performance Issue