Need Help On Set Analysis

ashfaq_haseeb — Mon, 12 Jul 2010 14:09:34 GMT

Dear all

I have 5 years of data in my application.

I need to calculate few dimensions like sum(amount Received) etc for specific two years. based on time calender. If nothing selected then it should consider it as a current year for which i use if with setanalysis

I have a straight table with gls class as dimension

expression is as follows

if(year,sum({Year=Year>} Price),sum({$(Year)= { $(vCurrentYear)}>} Price)

where year is comming from master calander and vCurrentYear is a variable which hold current year value

this give me exactly what i want

now what I want is I need to divide Price of each gl class by total price of all gl class which is calculated in first dimension.

o/p of straight table is

GL CLASS VALUE VALUETOBECALCULATED

01 5 5/1500

02 10 10/1500

0N 1500

how to acheave this

Thanks and Regards

ASHFAQ

How would i do this

I tried this

Need Help On Set Analysis

ashfaq_haseeb — Mon, 12 Jul 2010 17:28:00 GMT

any one can please reply on this issue

Need Help On Set Analysis

pover — Mon, 12 Jul 2010 19:42:54 GMT

Ashfaq,

Try using the total keyword. For example, sum(Price)/sum({$<[GL CLASS]={'0N'}>} Total Price).

Regards, Karl

Need Help On Set Analysis

ashfaq_haseeb — Tue, 13 Jul 2010 13:52:44 GMT

Thanks Karl

It worked out.

I thanks a ton. Every time you helped me a lot.

topic Need Help On Set Analysis in QlikView

Need Help On Set Analysis

Need Help On Set Analysis

Need Help On Set Analysis

Need Help On Set Analysis