Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
krish2459
Contributor III
Contributor III

Top 10 :: Total % Value Issue

Hi,

 

I'm using line chart to plot trend for Material stock correction at plant and Monthyear level.

 

But I'm getting Total percentage as negative which is wrong.

I'm limiting only top 10 materials.It seems like logic is taking entire value.

 

I need to limit logic to pick only top 10 materials at expression level.

Expression: 

(1-(fabs(sum(Amount))


/sum([Stock Value Main])))*100

 

krish2459_1-1616650798882.png

 

 

Thanks,

Krish

Labels (1)
4 Replies
krish2459
Contributor III
Contributor III
Author

Any Suggestions.

 

Thanks,

Krish

MayilVahanan

HI @krish2459 

Change the totals function from Auto to Sum in expression

MayilVahanan_0-1616659180361.png

 

Thanks & Regards,
Mayil Vahanan R
krish2459
Contributor III
Contributor III
Author

Hi @MayilVahanan 

I'm using line chart.

We need to restrict in expression.

 

Thanks,

Krish

MayilVahanan

HI @krish2459 

Can you provide the sample file to verify

Thanks & Regards,
Mayil Vahanan R