topic Re: Re: Formula in QlikView

Formula

deepakqlikview_123 — Wed, 30 Apr 2014 12:22:35 GMT

Hi All,

I have used rangesum function previously as per below

=RangeSum(Alt(Before([Total Analysis]), 0), count(CHASSIS_NUMBER))

It was working fine.

But now I have calculated percentage by using below formula.

=Num((( sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)),'#,#0%' )

Can you please suggest hoe to use rangesum function in above formula.

Thanks

Re: Formula

MK_QSL — Wed, 30 Apr 2014 12:25:07 GMT

Not getting your question properly. Could you please elaborate little more !

Re: Formula

deepakqlikview_123 — Wed, 30 Apr 2014 12:29:12 GMT

Hi Manish,

As per requirement I want to apply rangsum function for percentage whatever calculated in below mentioned formula

=Num((( sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)),'#,#0%' )

Thanks

Re: Formula

MK_QSL — Wed, 30 Apr 2014 12:35:17 GMT

Not sure below will work on not... but nothing wrong in trying...

=NUM((RangeSum(Before(sum({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>} MAN_ON_ROLE),0,RowNo()))

RangeSum(Before(sum({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>} PRESENT),0,RowNo())))

RangeSum(Before(sum({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>} MAN_ON_ROLE),0,RowNo())),

'#,#0%' )

Re: Formula

deepakqlikview_123 — Wed, 30 Apr 2014 12:41:21 GMT

Hi Manish,

It is not showing excepted results.

Thanks.

Re: Formula

MK_QSL — Wed, 30 Apr 2014 12:43:27 GMT

If possible, please provide sample data in excel file along with your requirements.

only 5-10 like would be ok to work.

Re: Re: Formula

deepakqlikview_123 — Fri, 02 May 2014 08:44:58 GMT

Hi Manish,

Please find attached QVW file contains sample data.

Please suggest how to use Rangesum function in above formula.

Thanks,

Re: Formula

MK_QSL — Fri, 02 May 2014 08:55:58 GMT

There is no DeptFlag in your data model.

use below

=num(

(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' )

Re: Formula

deepakqlikview_123 — Fri, 02 May 2014 09:01:08 GMT

HI manish,

How to use rangesum function in above formula.

Thanks

Re: Formula

MK_QSL — Fri, 02 May 2014 09:07:21 GMT

NUM(

(

RangeSum(YourFirstExpression)

RangeSum(YourSecondExpression)

)

/RangeSum(YourFirstExpression),

'#,##0.00%')

Re: Formula

deepakqlikview_123 — Fri, 02 May 2014 09:19:32 GMT

Hi Manish,

As per requirement I need to show result as

day2 data=Day1 data+day 2 data

day3 data=Day1 data+day 2 data +day 3data

day4data=Day1 data+day 2 data +day 3data+day 4data

As per column in above QVW file for data whatever we have calculated by using above formula.

By using above expression for rangesum not getting excepted result

Thanks

Re: Formula

MK_QSL — Fri, 02 May 2014 09:26:37 GMT

NUM((RangeSum(Above(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo()))

RangeSum(Above(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT),0,RowNo())))

RangeSum(Above(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo())),'#,#0%)

NUM((RangeSum(Before(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo()))

RangeSum(Before(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT),0,RowNo())))

RangeSum(Before(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo())),'#,#0%')

Re: Formula

deepakqlikview_123 — Fri, 02 May 2014 09:28:51 GMT

Its working