Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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!!!