Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If else expr issue

Hi all,

=if(Group1='PBT' or Group1='DEPRECIATION' or Group1='FINANCIAL EXPENSES',if(getselectedcount('FinYear')=1,sum(IF(ISNULL(GL_Amount),0.00001,GL_Amount)),sum({<Year={$(=max(Year))}>}IF(ISNULL(GL_Amount),0.00001,GL_Amount))),

ifGroup1='Increase in Payables' or Group1='Increase in Receivables' OR Group1='Less-Tax Provision' or Group1='Cash & Cash Equivalaent in Various banks' or
Group1='Increase in Investment' or Group1='Term Loan Disbursement' or Group1='Increase in Share Capital' or
Group1='Cash & Cash Equivalaent in Various banks' or Group1='Investment in FMP & Mutual Funds'  OR Group1='Increase in Inventory' OR Group1='Increase in Other C/Assets' or
Group1='Increase in Payables',sum(if(date(Posting_Date)>= $(MinSelectedDate) and date(Posting_Date)<= $(MaxSelectedDate) AND Division_Code<>'MO',IF(ISNULL(GL_Amount),0.00001,GL_Amount))),
if(Group1='PROFIT AFTER TAX',$(vProfitAfterTax),
if(Group1='Cash Profit',$(vCashProfit),

if(Group1='Change in C/L',$(vChangeinCL),

if(Group1='Increase in Other Liabilities',$(IncrinOtherLiabilities),
if(Group1='CAPEX incl. CWIP',$(vCapex),
if(Group1='B',$(vB),
if(Group1='A',$(vA),
if(Group1='Interest payment',$(vInterestpayment),
if(Group1='Change in C/A',$(vChangeinCA),

if(Group1='Term Loan Repayment/ Bank Borrowings',$(vTermLoanRepay),
if(Group1='Dividend payout incl. Dividend Tax',$(vDividend),



sum(IF(ISNULL(GL_Amount),0.00001,GL_Amount)))))))))))))))

Change in C/A and Change in C/L values are not coming in straight table,but when i write separate expressions

if(Group1='Change in C/L',$(vChangeinCL),

if(Group1='Change in C/A',$(vChangeinCA)))

then the value comes,

plzz suggest what is wrong in this expr.

0 Replies