Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion
Champion

Re: How can we show only 3 digits out of million

Navdeep,

Define a variable: Ctrl+Alt+V->add->VariableName(Say VLakh)=100000

Then in your expression try:   YourExpression/VLakh

Hope this will help

Highlighted
Not applicable

Re: How can we show only 3 digits out of million

Yes, but then send to excel will give that divided value.

Highlighted
Champion
Champion

Re: How can we show only 3 digits out of million

True, but nothing can be done here. Even if you are defining symbol, you would get same.

For that, you can show a flag in chart header(like All values are in Lakhs)

Highlighted
Partner
Partner

Re: How can we show only 3 digits out of million

Hello

I don't know if this stil an issue but I would try  using double() where in text part  I would show what I need to show and in numerical part what I need to have.

hope it helps!

Highlighted
Not applicable

Re: How can we show only 3 digits out of million

Hi, maybe so

sum.JPG

Highlighted
Not applicable

Re: How can we show only 3 digits out of million

Ok Yes, that flag is already there 🙂

Highlighted
Specialist III
Specialist III

Re: How can we show only 3 digits out of million

hi,,

Delete the chart and create again ,

Highlighted
Not applicable

Re: How can we show only 3 digits out of million

Hi,

Can you share your qvw.

Regards,

Navdeep