topic Re: Addition of fields in script in QlikView

Addition of fields in script

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have create two calculate columns in script 1.Approved days, 2. Rejected days

based on this trying to get Total Days of Both using

Approved days+Rejected days as Total_Days But not getting expected values.

Out of that based on using Total_Days trying to display in Textbox object

1.if Total_Days <=5 than Count (number)

2. if Total_Days >=5 than Count(number).

Can any one suggest the solution.

Thanks

Rajesh

YoussefBelloum — Thu, 14 Jun 2018 12:30:21 GMT

Hi,

would you be able to add more details? like sample data or sample app

Chanty4u — Thu, 14 Jun 2018 12:32:57 GMT

what is the column values of approved days and rejected days?

Rajesh — Thu, 14 Jun 2018 12:40:52 GMT

Numeric values and NULLs

Chanty4u — Thu, 14 Jun 2018 12:48:47 GMT

may be

Totals:

load

Field1,

sum(Approved) +sum(rejected) as Total

resident Data

group by Filed1,Field2;

if(total<=5,count(total),count(total)