Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
hic
Former Employee
Former Employee

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

May be this:

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

/

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

amit_saini
Master III
Master III

try:

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

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

Thanks,
AS

Not applicable
Author

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