topic Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ? in QlikView

How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

yanivvl0 — Mon, 09 Jun 2014 07:54:54 GMT

hi every one ,

i am new in QV , and use to think SSAS Olap ,so i want to perform what i wrote in the head line :

to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

for example if in the (table) chart there is months
dimension and sales measure - i need to see the difference ( as another measure )

between any month and the previus month - FOR ALL MONTHS , like :

	sales	diff prev sales	sales	diff prev sales	sales	diff prev sales	sales	diff prev sales
	100	2	110	10	90	-20	200	110
month	3		4		5		6

as u see in apr the sales = 110 and the diff between mar =
110 - 100 = 10 , and so on for all .......

in ssas it is very simple and natural , here in QV ,

i have tried to use set analysis but its solve the problem
for 1 month only ,

- can any one SAVE me ? Thanking you in anticipation.

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

jagannalla — Mon, 09 Jun 2014 08:08:39 GMT

Hi,

Please find the attachment.

Hope it helps you

Cheers!!

Jagan

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

tresB — Mon, 09 Jun 2014 08:12:03 GMT

See this blog: Calculating rolling n-period totals, averages or other aggregations to understand how to refer a value not there in dimension scope using Aggr() and set analysis. To get specific help, try to post your sample app.

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

yanivvl0 — Mon, 09 Jun 2014 11:29:47 GMT

GREAT help - perfect solution - thank u jagan!!

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

jagannalla — Mon, 09 Jun 2014 11:35:41 GMT

Can you mark as correct answer

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

yanivvl0 — Mon, 09 Jun 2014 12:52:26 GMT

yes , sorry but how can i do it ? i'm new here ..

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

jagannalla — Mon, 09 Jun 2014 12:55:22 GMT

Select on proper answer post and choose correct answer.

For eg:

My post is correct one, so you can click on Correct answer.

But you had selected your post as correct, plz uncheck it and select on my correct post.

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

yanivvl0 — Mon, 09 Jun 2014 12:55:35 GMT

thank u !! i have learn much from this link - much help.

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

yanivvl0 — Mon, 09 Jun 2014 12:56:37 GMT

DONE

topic Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ? in QlikView

How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

sales

diff prev sales

sales

diff prev sales

sales

diff prev sales

sales

diff prev sales

month

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?

Re: How to compare ( or to do other math actions ) between all dimension members - not only between select member and other member ?