topic Re: logic help in QlikView

logic help

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

can anyone tell me how get this output?

This is my data.

Sample:

LOAD * INLINE [

Company, Sub, Id, Exp 1, Exp 2

ABC, A1, 1, 5, 8

ABC, A1, 2, 10, 13

ABC, A1, 3, 13, 16

ABC, A1, 4, 15, 18

ABC, A1, 5, 17, 20

ABC, A2, 6, 19, 22

ABC, A2, 7, 20, 23

ABC, A2, 8, 25, 28

ABC, A2, 9, 30, 33

];

Output:

Company	Sub	Id	Exp 1	Exp 2	Logic
ABC	A1	1	5	8
ABC		2	10	13
ABC		3	13	16
ABC		4	15	18
ABC		5	17	20
ABC	A2	6	19	22	19
ABC		7	20	23	20+(23-22)
ABC		8	25	28	25+(28-23)
ABC		9	30	33	30+(33-28)

Re: logic help

harishkumarg — Thu, 20 Oct 2016 05:05:13 GMT

Logic columns is needed only for Sub = A2?

Regards

Harish

Re: logic help

subbareddykm — Thu, 20 Oct 2016 05:05:25 GMT

Re: logic help

subbareddykm — Thu, 20 Oct 2016 05:06:43 GMT

yes, that is my max sub area, from max sub only i need to caluculate .

Re: logic help

prat1507 — Thu, 20 Oct 2016 05:28:54 GMT

PFA the .qvw for your reference. I've implemented the logic you want.

Regards

Pratyush

Re: logic help

harishkumarg — Thu, 20 Oct 2016 05:30:01 GMT

Please find the attached QVW.

Hope this helps!

Regards

Harish

Re: logic help

Anil_Babu_Samineni — Thu, 20 Oct 2016 05:33:47 GMT

Try This

(RangeSum(Sum([Exp 1]),Sum([Exp 2])))-Above(Sum([Exp 2]),1)

Re: logic help

harishkumarg — Thu, 20 Oct 2016 05:36:08 GMT

Output:

Regards

Harish

Re: logic help

akash3191 — Thu, 20 Oct 2016 05:39:54 GMT

Hi Subbareddy,

Please find the attached application. It contains the output you want. Hope this helps.

Thanks,

Akash.

Re: logic help

Anil_Babu_Samineni — Thu, 20 Oct 2016 05:43:20 GMT

Harish, What logic you have written over there? I don;t have S/W in hand

Re: logic help

subbareddykm — Thu, 20 Oct 2016 05:48:02 GMT

will it check everytime maximum sub area ?

Why bcoz i have next sub area i need to caluculate from the max sub.Will it work that time ?

Re: logic help

harishkumarg — Thu, 20 Oct 2016 05:51:42 GMT

Yup, if you have a sub area named A3 coming then the logic column will show values for A3 alone and not A1, A2.

I checked by giving some random values for A3. It worked.

Regards

Harish

Re: logic help

harishkumarg — Thu, 20 Oct 2016 05:55:54 GMT

Hi Anil babu

Please find the below logic

Pivot Table:

Dimensions –

Company, Sub, ID

Measures -

Exp1 =Sum(Exp1)

Exp2=Sum(Exp1)

Logic =If(Right(Sub,1)=Max(Total<Company>Right(Sub,1)),If(RowNo()=1,Exp1,(Exp1+Exp2)-(RangeSum(Above(Exp2,1)))))

Regards

Harish

Re: logic help

harishkumarg — Thu, 20 Oct 2016 05:58:28 GMT

I assume that max sub is calculated based on its ID like A1, A2, A3.

Please let me know if max sub is calculated based on dif logic.

Regards

Harish

Re: logic help

subbareddykm — Thu, 20 Oct 2016 06:06:51 GMT

Thankq harish,

But i f i remove Sub and Company from dimentions , values are coming wrong

My requirement is to show in combo chart , i have id as dim rest exp are same.

Re: logic help

harishkumarg — Thu, 20 Oct 2016 06:11:14 GMT

Can you show some sample image of what you are expecting your output to be.

Regards

Harish

Re: logic help

subbareddykm — Thu, 20 Oct 2016 06:19:32 GMT

Values are correct if have Sub in dimention,but i want same values if i take ID dim also.

Re: logic help

tamilarasu — Thu, 20 Oct 2016 06:38:28 GMT

Hi,

Always try to explain the question clearly. Your last question is deviating from your initial question. Check the attachment.

Re: logic help

subbareddykm — Fri, 21 Oct 2016 06:30:28 GMT

hi Nagaraj,

One issue coming again ,

If i take dim as Date instead of date it is showing number.

Can u tell me solution for it ?

Re: logic help

tamilarasu — Fri, 21 Oct 2016 06:46:40 GMT

Hi Subbareddy,

You can use calculated dimension like below.

=Date(Datefield,'YourFormat')

Ex: =Date(Cal.Date,'DDMMYYYY')

If it's not working, I would suggest to post a sample file.