Qlik Community

Ask a Question

New to QlikView

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Is it Possible to have two different formats of values for Single Expression?

Hello Everybody,

          I have one requirement to show values in two different formats for the same expression is it possible in qlikview..

          Eg:

               i want to show the Expression say Sum(Amount) in Integer Format & also in percentage format in a single column

               is it possible in qlikview.

Thanks in Advance,

Priya

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Hi,

     Try this.

     num(Sum(Amount),'#,##0.00') &'-'& num(Sum(Amount)/Sum(total Amount),'#,##0.00%')

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

Hi,

     Try this.

     num(Sum(Amount),'#,##0.00') &'-'& num(Sum(Amount)/Sum(total Amount),'#,##0.00%')

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post