topic Re: Adding calculated field based on exp pivot table in QlikView

Adding calculated field based on exp pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have a table with

cost center,employee name,project name,year-week,planning hours

so whenever there is no planning hours (meaning planning hours=0 ) i am not getting recor since suppress zero value is checked.

Now the requirement is to show employees even though the planning hours=0.But they dont want to see project name.

generally this is what iy comes if i allow zero.

cost center,employee name,project name,year-week,planning hours

CC,name,proj1,year-week,0

CC,name,proj2,year-week,0

CC,name,proj3,year-week,0

but need is,

CC,name,' ',' ',' '

kindly help.

Re: Adding calculated field based on exp pivot table

rahulpawarb — Fri, 10 Mar 2017 07:06:16 GMT

Hello Prajna,

Please use below given calculated dimensions & expressions:

//project name
=If([planning hours]>0, [project name], '')

//year-week
=If([planning hours]>0, [year-week], '')

//planning hours
=If([planning hours]>0, [planning hours], ' ')

Regards!

Rahul

Re: Adding calculated field based on exp pivot table

Fri, 10 Mar 2017 07:33:24 GMT

if i give this in dimension i was getting error in calculation dimension..but if i use aggr function is not throwing error.

so em stuck

Regards,

Prajna

Re: Adding calculated field based on exp pivot table

rahulpawarb — Fri, 10 Mar 2017 07:42:32 GMT

Hello Prajna,

Could you please share the application with sample data? This will help me to provide your expected response.

Regards!

Rahul

Re: Adding calculated field based on exp pivot table

nagarjuna_kotha — Fri, 10 Mar 2017 08:07:59 GMT

this information is not enough,

Try to share sample data along with expected results.

-nagarjun