topic Re: Granularity issue in QlikView https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618485#M227920 <HTML><HEAD></HEAD><BODY><P>If you have lot of Text values and all unique then rendering would be slow on UI</P></BODY></HTML> Wed, 09 Apr 2014 15:06:58 GMT 2014-04-09T15:06:58Z Granularity issue https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618482#M227917 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I got one dimension in my pivot chart whose granularity is per row. When number of rows grows bigger then report loads very slow. This dimension is one of the columns in the fact table.</P><P>May I know the reason behind it?</P><P>This </P><P>Saurabh</P></BODY></HTML> Wed, 09 Apr 2014 10:41:55 GMT https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618482#M227917 2014-04-09T10:41:55Z Re: Granularity issue https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618483#M227918 <HTML><HEAD></HEAD><BODY><P>Check in the expression if there nested if condition that may cause that the chart is load slowly. If expression contains if nested condition time increases in the chart and ram is consumed also if so then use SET analysis in the chart for the expression.</P><P></P><P>Regards</P></BODY></HTML> Wed, 09 Apr 2014 10:45:39 GMT https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618483#M227918 its_anandrjs 2014-04-09T10:45:39Z Re: Granularity issue https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618484#M227919 <HTML><HEAD></HEAD><BODY><P>I have a simple If statement and when i replace this highest granular dimension with lesser one then reports works very fast.</P></BODY></HTML> Wed, 09 Apr 2014 15:02:32 GMT https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618484#M227919 2014-04-09T15:02:32Z Re: Granularity issue https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618485#M227920 <HTML><HEAD></HEAD><BODY><P>If you have lot of Text values and all unique then rendering would be slow on UI</P></BODY></HTML> Wed, 09 Apr 2014 15:06:58 GMT https://community.qlik.com/t5/QlikView/Granularity-issue/m-p/618485#M227920 2014-04-09T15:06:58Z