Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
munna1317
Creator II
Creator II

Problem in Set analysis

hi QVs,

Plz help me the requirement is in Excel plz help

regards harish

19 Replies
Not applicable

what is the logic to get that column?

avinashelite

Hi Harish,

Can you please provide the formula to calculate the output column

munna1317
Creator II
Creator II
Author

hi Avinash ,

No formula is there the output table must be develop , in QlikView i have one idea ,

but at 200000 its getting minus value , plz find the attactment

munna1317
Creator II
Creator II
Author

i need to implement logic if logic is there it is easy to get the result

thxs

harish

JonnyPoole
Employee
Employee

I agree  with Avinash R and QV Learner... what does the last column mean ?  If there is no formula for it in excel please describe what it actually is.

munna1317
Creator II
Creator II
Author

hi jonathan ,

Plz find the attachment ,

and plz check the Cumulativesum3 field you will idea about requirement,

Thxs ,

Harish

avinashelite

Hi Harish,

Can you please explain the logic that your following...I saw your qvw, peek(cummsum) for few values its taking null values that's why its showing minus values.

If you explain the logic, it will be helpful for us to give the solution.

munna1317
Creator II
Creator II
Author

hi ,

plz check this :

if(ChangeFlag2=1,left(CumulativeSum,1)+1 & repeat('0', len(CumulativeSum)-1), peek(CumulativeSum2)) as CumulativeSum2

here i am taking the left most character of Cumulative add addng that one ,

but at step of

NameDateYearSalesCommissionCumulativeSumCumulativeSum3
Harish12/28/2014201415160.02148466200000
Harish12/29/2014201451370.025153603-46397
Harish12/30/2014201464680.025160071-39929

here it should taking left(CumulativeSum,1) is 1 that is problem iam getting but it should take 14 +1 =15 the output will be correct :

Expected Out put

NameDateYearSalesCommissionCumulativeSumCumulativeSum3
Harish12/28/2014201415160.02148466150000
Harish12/29/2014201451370.0251536033603
Harish12/30/2014201464680.02516007110071

like this it will come any idea about this logic

munna1317
Creator II
Creator II
Author

the blind logic is for every end of different commission the Cumulative sum must be Round with Below cumulative sum and the it shoould starts form

if(ChangeFlag2=1,  CumulativeSum2, CumulativeSum - alt(CumulativeSum2,0)) as Cumulativesum3

like this some logic i got in mind when seeing that excel

thxs ,

Harish