topic Re: Query regards the dimension level in QlikView

Query regards the dimension level

sarfaraz_sheikh — Tue, 17 Feb 2015 09:34:43 GMT

Dear All,

I have the below data:----

Product Premium

A 100

B 35

C 50

D 60

E 55

I want to print like below :-

Product Premium

A 100

B 35

A-B 65

C 50

D 60

E 55

Is this possible in qlikview ...if yes then how can do this ....

Sarfaraz

Re: Query regards the dimension level

sarfaraz_sheikh — Tue, 17 Feb 2015 10:02:43 GMT

kindly reply ....Its urgent ..........I tried but unable to achive the same ......

Sarfaraz

Re: Query regards the dimension level

richard_chilvers — Tue, 17 Feb 2015 10:04:50 GMT

Hi Sarfaraz

I think you might need to give a bit more detail about what you're trying to achieve.

For example, why do you subtract B from A only ? Are there other subtractions?

Re: Query regards the dimension level

sarfaraz_sheikh — Tue, 17 Feb 2015 10:15:59 GMT

Hi rechard,

There is requirement from business user to print like this .....I have products list however among product i want particular product volume to get substracted from another particular product volume ...

Is there any way to achive this ...If yes then kindly let me know how i can do this

Sarfaraz

Re: Query regards the dimension level

richard_chilvers — Tue, 17 Feb 2015 10:45:52 GMT

Hi Sarfaraz

How do you know which products to subtract from each other?

You will need to build these rules into your model so QlikView can do the calculations.

You might want to look at Chart Inter Record functions in the help.

Re: Query regards the dimension level

sarfaraz_sheikh — Tue, 17 Feb 2015 11:27:10 GMT

Dear Richard,

I know which one shoud get substract with which one.

How i can build these rule in qlikview model .......Can you keep any example here for my understanding

Sarfaraz

Re: Query regards the dimension level

richard_chilvers — Tue, 17 Feb 2015 11:57:39 GMT

You might like to load this little script to see how it might work.

Of course, your data would need to come from the data source/database you are using.

It is not an elegant solution I'm afraid. But you could improve on it, depending on what your requirements are.

Good luck.

Products:

LOAD * INLINE [

Product, Premium
A , 100
B, 55
C, 50
D, 60
E, 55

];

LOAD 'A-B' AS Product, LOOKUP('Premium','Product','A','Products')-Premium AS Premium
RESIDENT Products WHERE Product = 'B';
EXIT SCRIPT;