Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data is not showing as a percentage

I'm looking at a report setup by someone else and I can't figure out why the data for "Plan Rate" is showing as 0.03 instead of 3.0%

Below is the definition of the expression called "Plan Rate"

(sum({$<//PlanYear={$(=max(Year))},

Year={$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Comp'},

CompletePeriodFlag={1}

>}

 
NET_SALES * (1 + if(isnull([Target Growth %])=-1,0,[Target Growth %])))

/

sum({$<//PlanYear={$(=max(Year))},

Year={$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Com'},

CompletePeriodFlag={1}

>}

 
NET_SALES)-1

> 0,

sum({$<//PlanYear={$(=max(Year))},

Year={$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Comp'},

CompletePeriodFlag={1}

>}

NET_SALES * (1 + if(isnull([Target Growth %])=-1,0,[Target Growth %])))

/

sum({$<//PlanYear={$(=max(Year))},

Year={$(=max(Year)-1)},

DepartmentNo={80},

StoreStatus={'Board Comp'},

CompletePeriodFlag={1}

>}

NET_SALES)-1)

I looked at the Number Format Settings and it seems correct:

Plan Rate Number Format Setting.jpg

1 Solution

Accepted Solutions
Not applicable

Re: Data is not showing as a percentage

Thanks for the quick response. I believe I was looking at a disabled expression. So the problem is somewhere else.

Thanks anyway.

3 Replies
antoniotiman
Honored Contributor III

Re: Data is not showing as a percentage

Try

Num(Expression,'#,##0.0 %')

Antonio

MVP
MVP

Re: Data is not showing as a percentage

Looks like some problem...

is there any IF function you have used in this expression?

Not applicable

Re: Data is not showing as a percentage

Thanks for the quick response. I believe I was looking at a disabled expression. So the problem is somewhere else.

Thanks anyway.

Community Browser