Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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