topic Re: Summary Report in QlikView

Summary Report

tyagishaila — Mon, 04 May 2015 07:20:19 GMT

Hi All,

I have a straight table, I need a summary report of this table

Summary report represent No of Lines (Total Rows) on different different conditions .

Please help me out how can achieve this.

Below is the ex of summary report:

VOLUME LINES EXCEPTION SUMMARY
EXCEPTION		WOMENSWEAR	MENSWEAR	LINGERIE	TOTAL
No of lines with "Store Week Cover" less than	4	13	13	4	30
No of lines with zero BTF, but wh available		1	3	5	9	(curr wh stks>10); btf=0
No of lines with wh avail % higher than	0.50%	18	32	25	75
Lines with No balance on order		78	139	76	293	BOO less than 10 sgls
No of lines not acc to cat plan		100	107	63	270	where plan cat is not equal to actual cat

Re: Summary Report

datanibbler — Mon, 04 May 2015 07:39:31 GMT

Hi shaila,

if you already have a straight table, then you also have those dimensions, right?

=> Just create a second straight table with those two dimensions and just the COUNT of lines (if necessary, just use rowNo() in the script to have a line_ID) as expression.

=> Then put that into a report (to print out).

HTH

Re: Summary Report

tyagishaila — Mon, 04 May 2015 08:23:40 GMT

Hi Nibbler,

Thanks for quick reply,

I did this but , With this I got values of expression but I need only count.

Well I solve it for now.. but not happy with long method which I follow.

Thanks for your reply.