Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Solved

Solved

1 Solution

Accepted Solutions
sunny_talwar

6 Replies
sunny_talwar

I really want to help, but I was not able to find the link to the previous discussions where me and others have provided a similar solution. May be kush7337‌ can help us find a previous discussion

Anonymous
Not applicable

Hi,

I think that a combination with Pick, Dimensionality and Dual functions can do it.

Pick(Dimensionality()+1,

     Expr0 -> Dual(Num(ExprMonthly,'#.##0')&chr(10)&Num(ExprPercent,'#.##0%')

     Expr1 (Your expression for calculate Monthly income)

)

On Presentation, in label for totals -> ='Monthly Income'&chr(10)&'%'

Regards!

microwin88x
Creator III
Creator III
Author

Hello stalwar1I attach my QVW sample. Hope you can help! Thanks in advance

Anonymous
Not applicable

Hi microwin88x,

I have attached you your example with my comment.

Regards

sunny_talwar

May be this

Capture.PNG

microwin88x
Creator III
Creator III
Author

Hello Manuel, thanks for your answer.

The example is visually ok, but the thing is that I need to export that table to Excel.

And when I do that, I see the following:

Sin título.png

Note that the subtotal is concatenated to the total, I would need that information in 2 Rows. For example:

Sin título 2.png

Thank you!!!