topic Re: Pop up label help in QlikView

Pop up label help

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Fri, 07 Oct 2016 19:05:41 GMT

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 — Fri, 07 Oct 2016 19:08:56 GMT

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

rupamjyotidas — Fri, 07 Oct 2016 19:57:16 GMT

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 — Fri, 07 Oct 2016 19:59:04 GMT

How are location and description related to each other?

apthansh — Mon, 10 Oct 2016 15:48:49 GMT

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 — Mon, 10 Oct 2016 16:12:43 GMT

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