topic Re: Please Required Urgent Help in QlikView

Please Required Urgent Help

VishalWaghole — Fri, 27 Sep 2013 10:10:22 GMT

Hi Community,

Please Find attached Data.

I need Out-Put like this

	Opening Balance (Nov 12 to Mar 13)	May 13	Jun 13	Jul 13
Total files audited	243	48	66	43
Total files with Exception	131	19	42	19
Total files without Exception	112	29	24	24

In Excel Exception Column Contains Y and N Value.

Y = Exception

N = Without Exception.

Please Could any one have possible to solve this issue.

Thanks and Regards,

Vishal Waghole

Fri, 27 Sep 2013 10:32:12 GMT

By using calculated dimension.. you can achieve this..

Go thought below link..

(See G Wassennar reply)

Karthik

adamwilson — Fri, 27 Sep 2013 10:38:13 GMT

Here are the figures you need, having it in the one table you may have to use a calculated dimension like Karthikeyan S suggested

tresB — Fri, 27 Sep 2013 10:41:23 GMT

PFA. Hope this helps.

VishalWaghole — Fri, 27 Sep 2013 11:01:47 GMT

You right but i want that charts only based on expression not on dimension.

By default we can make total by adding month but i want that total which is based on expression.

Thanks for your reply.

tresB — Fri, 27 Sep 2013 12:22:17 GMT

PFA.

I have shown both dynamic(colored ones) and static ways