Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this code I want to convert to Qlikview:
sum(GRANTED_FACILITY_AMT) CELL_VALUE |
from CRI_NCA_AS..FACT_APPLICATIONS_JUN2015 |
where PRODUCT_CODE='MLOAN' |
and REG_LAST_3MONTHS_IND='Y' |
group by case MLOANS_BANDS_CODE |
Please assists,
Mbini
You can try this:
sum(
if(
PRODUCT_CODE='MLOAN'
and
REG_LAST_3MONTHS_IND='Y'
and
match(MLOANS_BANDS_CODE,'A','B','C','D','E','F')
,FINAL_ML_AMT
)
Please try like below:
LOAD
MLOANS_BANDS_CODE,
sum(GRANTED_FACILITY_AMT) CELL_VALUE |
from CRI_NCA_AS..FACT_APPLICATIONS_JUN2015.qvd (qvd) |
where Match(PRODUCT_CODE,'MLOAN') |
and Match(REG_LAST_3MONTHS_IND,'Y') |
group by case MLOANS_BANDS_CODE |
;
Hi,
But i want to put this code on the front end
I have tried this code:
if(match(PRODUCT_CODE,'MLOAN') and match(REG_LAST_3MONTHS_IND,'Y') and match(MLOANS_BANDS_CODE,'A','B','C','D','E','F'),sum(FINAL_ML_AMT))
Let us assume you have all these 4 fields on data model, you can do with set analysis.
Create Straight table or other required chart with Dimension & Expressions.
Dimension: MLOANS_BANDS_CODE
Expression: sum({<PRODUCT_CODE={"MLOAN"},REG_LAST_3MONTHS_IND={"Y"}>}GRANTED_FACILITY_AMT)
If you want show total value on the Text Object simply use the above expression on text object.
on which object you are trying the expression ?
You can try this:
sum(
if(
PRODUCT_CODE='MLOAN'
and
REG_LAST_3MONTHS_IND='Y'
and
match(MLOANS_BANDS_CODE,'A','B','C','D','E','F')
,FINAL_ML_AMT
)
Make a chart (bar chart, pivot table, or what you want) and use the following:
Dimension: MLOANS_BANDS_CODE
Expression: Sum({$<PRODUCT_CODE={'MLOAN'}, REG_LAST_3MONTHS_IND={'Y'}>}
GRANTED_FACILITY_AMT)
HIC
it complains about the syntax of this code!!
It complains about the syntax on the code