topic Re: How to use TOtal Qualifier with 2 dimensions in QlikView

How to use TOtal Qualifier with 2 dimensions

Anonymous — Fri, 10 Jun 2016 19:04:19 GMT

Hi all, Total is now working in my example.

I need % calc that gives me 10/60 as a % for A-1. for that I am using

sum({<Type ={'Preferred'}>} Amt)/

sum( Total <ProductID>{<Type ={'Preferred'}, [Contract No] ={'*'}>} Amt)

but it only displays correct result in my straight table when both productID & Contract No are selected. I want it to work when only contract No is selected.

Many Thanks

ProductID	Contract No	Amt	Type
A	A-1	10	Preferred
A	A-2	20	Preferred
A	A-3	30	Preferred
B	B-1	1	Preferred
C	C-1	2	Reg
C	C-2	3	Reg

Re: How to use TOtal Qualifier with 2 dimensions

sunny_talwar — Fri, 10 Jun 2016 19:06:53 GMT

Try this:

Aggr(Sum({<Type ={'Preferred'}>} Amt)/Sum(Total <ProductID> {<Type ={'Preferred'}, [Contract No] ={'*'}>} Amt), ProductID, [Contract No])

Re: How to use TOtal Qualifier with 2 dimensions

sunny_talwar — Fri, 10 Jun 2016 19:08:47 GMT

Sample attached

Re: How to use TOtal Qualifier with 2 dimensions

Anonymous — Fri, 10 Jun 2016 19:36:51 GMT

sunny, Thanks very much for quick reply. the problem is when contract No is not selected, it shows '-', null. when a contract no is selected, your soln works. should I use getfieldselection, ?

Re: How to use TOtal Qualifier with 2 dimensions

sunny_talwar — Fri, 10 Jun 2016 19:39:00 GMT

In the image above, I have not selected any Contract No. I am not sure what you mean?

Re: How to use TOtal Qualifier with 2 dimensions

swuehl — Fri, 10 Jun 2016 21:01:02 GMT

You need to specify which dimensions you are using, and if you are using any other specific settings in your application.

Also screen shots, or a more detailed verbal description of what you see when looking where and expecting what would really help to help you.

I assume you are talking about the total line in your straight table chart?

If you want to make your expression work, then try something like:

=sum({<Type ={'Preferred'}>} Amt)/

sum( Total <ProductID>{<Type ={'Preferred'}, [Contract No] ={'*'},ProductID=p()>} Amt)

=sum({<Type ={'Preferred'}>} Amt)/

sum( Total <ProductID>{<Type ={'Preferred'}, [Contract No] = ,ProductID=p()>} Amt)