Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck_bakytbek
Valued Contributor III

calculation only with content

Hi Folks,

i got a question (see attached screenshot)

Date,                   Act,                             Budget,                          Delta

27.02.2018             5350130,48                  6492000,00              1414896,52

28.02.2018               -                                   915000                       915000

where: Delta = Budget - Act

on 28.02.2018 i dont have any numbers in Position: Act, but in Position: Budget i have some numbers,

how can exclude the Amount 915000 in Position: Delta, i want to have only 1141896,52

Does anybody have any idea?

Thanks a lot

Beck

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: calculation only with content

May be -

if(len(Act)>0,Budget-Act,Above(Column(2)))

Or

if(len(Act)>0,Budget-Act,Above(Budget-Act))

4 Replies
Digvijay_Singh
Honored Contributor III

Re: calculation only with content

May be -

if(len(Act)>0,Budget-Act,Above(Column(2)))

Or

if(len(Act)>0,Budget-Act,Above(Budget-Act))

beck_bakytbek
Valued Contributor III

Re: calculation only with content

Hi Singh, Thanks a lot for responce, behind the Act and Budget i stored the variables, can i implement this way on variables?

Digvijay_Singh
Honored Contributor III

Re: calculation only with content

‌I think first option should work.

beck_bakytbek
Valued Contributor III

Re: calculation only with content

Hi Singh,

thanks a lot for your help and your valuable time

Have a nice evening

Community Browser