Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Pop up label help

HI ,

I have data as below...

ID    Description     Amt

1      Cloth             100

1      Grocery          200

1      Stationary       50

2      Garden        200

2      Paint            200

2      Stationary       400\

So sum(Amt) metrics I have to add label that shows Description as well.

I tried='Amount' &''& Description

Thats showing blank...how can I resolve this?

Thanks much

6 Replies
sunny_talwar

What is your Dimension here? ID or is it Description? If its ID, may be you need to do Concat(Description)

='Amount ' & Concat(Description, ', ')

apthansh
Creator
Creator
Author

I have another column called location and that is my Dimension...but tried the above label too...that is showing blank too...

rupamjyotidas
Specialist
Specialist

Probably this might help"

Remove 'Pop-up Labels' check in Presentation tab

Add a new equation : something like this

'Low: '&Sum(CountLow)&Chr(10)&

'Medium: '&Sum(CountMedium)&Chr(10)&

'High: '&Sum(CountHigh)&Chr(10)&

'Total: '&(Sum(CountLow)+Sum(CountMedium)+Sum(CountHigh))

Remove 'bar' or 'line' from display options and check only 'text as Pop Up'

sunny_talwar

How are location and description related to each other?

apthansh
Creator
Creator
Author

Common key called ExpenseID....

2 tables....Portfolio and Expense....Portfolio has ExpID ...each Id has location and same in expense table...each ExpID has Expense and description.

sunny_talwar

Ansh I don't think I completely understand, would you be able to share a sample with us?