Solved: Re: Straight table expression not working? - Qlik Community

Report Inappropriate Content · ‎2016-01-18

HI,

I have to write a expression based on below condition

IF Status='Open' then NUM(DataColumn1-DataColumn2)

I am trying to use if(Status=Open', NUM(DataColumn1-DataColumn2)). But straight table column is showing blank. table is not loading any data. Is there any error in expression? please can anyone suggest me

Thanks.

sunny_talwar · ‎2016-01-19

Try this may be:

Dimension:

1) Week(EnterDate)

2) CustomerID

Expressions:

Data1: Num(Only({<Status = {'Open'}>}DataColumn1)-Only({<Status = {'Open'}>}DataColumn2))

Data2: Num(Only({<Status = {'Closed'}>}DataColumn1)-Only({<Status = {'Closed'}>}DataColumn2))

Data3: Num(Only({<Status = {'Required'}>}DataColumn1)-Only({<Status = {'Required'}>}DataColumn2))

View solution in original post

sunny_talwar · ‎2016-01-18

May be try this:

=Only({<Status = {'Open'}>} DataColumn1 - DataColumn2)

Report Inappropriate Content · ‎2016-01-18

Hi,

Try the below one and see also the attached app,Hope it helps!!

=if(Status='Open',num(DataColumn1)-num(DataColumn2))

Report Inappropriate Content · ‎2016-01-18

Thanks. Tried this. still showing blanks

Report Inappropriate Content · ‎2016-01-18

Thanks. Tried this. still showing blanks

Report Inappropriate Content · ‎2016-01-18

Give this a try

=if(Match(Status,'Open'), Num(DataColumn1) - Num(DataColumn2))

Report Inappropriate Content · ‎2016-01-18

Could you post your sample app?

Anonymous · ‎2016-01-18

which is your dimension?, each category in your dimension can only have one status?

MarcoWedel · ‎2016-01-18

‌missing single quote.

regards

Marco

Report Inappropriate Content · ‎2016-01-19

dimension is only below one

Week(EnterDate)