topic Re: Set Identifier in QlikView

Set Identifier

Tue, 19 Jul 2016 10:45:38 GMT

Hi There,

I would to add an a filter on the expression below :

sum( {$<ValueMonth = {$(#vMaxCycle)} >} NrLoans )

/sum( {$<ValueMonth = {$(#vMaxCycle)} >} Total NrLoans )

what I would like to add : NarrationCat = 'Non Refund'

Thanks,

hic — Tue, 19 Jul 2016 12:02:03 GMT

If you want this ratio just for 'Non Refund', you should use

sum( {$<ValueMonth = {$(#vMaxCycle)} , NarrationCat = {'Non Refund'} >} NrLoans )

/sum( {$<ValueMonth = {$(#vMaxCycle)} , NarrationCat = {'Non Refund'} >} Total NrLoans )

However, if you instead want to see the ratio of 'Non Refund' as compared to all, you should use

sum( {$<ValueMonth = {$(#vMaxCycle)} , NarrationCat = {'Non Refund'} >} NrLoans )

/sum( {$<ValueMonth = {$(#vMaxCycle)} >} Total NrLoans )

HIC

sunny_talwar — Tue, 19 Jul 2016 12:02:41 GMT

May be this:

Sum( {$<ValueMonth = {$(#vMaxCycle)}, NarrationCat = {'Non Refund'}>} NrLoans)

Sum( {$<ValueMonth = {$(#vMaxCycle)}, NarrationCat = {'Non Refund'}>} TOTAL NrLoans)

amit_saini — Tue, 19 Jul 2016 12:03:30 GMT

try:

sum( {$<ValueMonth = {$(#vMaxCycle)} ,NarrationCat = {'Non Refund'} >} NrLoans )

/sum( {$<ValueMonth = {$(#vMaxCycle)} ,NarrationCat = {'Non Refund'}>} Total NrLoans )

Thanks,
AS

Tue, 19 Jul 2016 12:46:08 GMT

Thanks everyone, it help... Now the expression is working.