Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suvechha_b
New Contributor II

Please describe

Expression : if(columnno()<>0,$(vPerFormula)/$(vPerFormulaTotal),$(vPerFormula)/$(vPerFormulaPartialSum))

Not getting the if(columnno()<>0,,) and vPerFormula expression as well.

vPerFormula = sum({$<TranType = {$(vAmountType)},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Please if any body explain me.. will be helpful

4 Replies
qlikview2015
Contributor

Re: Please describe

Hi !

Which Field you want to check if there is a 0 ?

Best Regards

Mike Preuss

suvechha_b
New Contributor II

Re: Please describe

the expression is like this :

if(columnno()<>0,$(vPerFormula)/$(vPerFormulaTotal),$(vPerFormula)/$(vPerFormulaPartialSum))

qlikview2015
Contributor

Re: Please describe

You want to check if the ColumnNo is null.

if(columnno()<>0,                         $(vPerFormula)/$(vPerFormulaTotal),$(vPerFormula)/$(vPerFormulaPartialSum))

But you have to write a field in to the brackets i think, or?

suvechha_b
New Contributor II

Re: Please describe

It might be , if ColumnNo is null.

Please also help me in the following expression :

vPerFormula = sum({$<TranType = {$(vAmountType)},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)