Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Set Identifier

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,

4 Replies

Re: Set Identifier

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

Highlighted

Re: Set Identifier

May be this:

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

/

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

Highlighted
Honored Contributor III

Re: Set Identifier

try:

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

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

Thanks,
AS

Highlighted
Not applicable

Re: Set Identifier

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