topic Re: In Bar graph show the Pop Up Message in QlikView

In Bar graph show the Pop Up Message

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

Hi All,

Please help me ,

1. Scenario 1:

I have Bar char , in that country is the dimension and sum(sales) is my measure, in that having country wise sales information. Whenever mouse is placed on bar ,pop up is displaying.

I tried this code to display that one

Dual(City & Chr(10)&'Product Codes :'&Chr(10)&

Concat(DISTINCT Product ,Chr(10))& Chr(10)&

'% Gain='& Num((Sum(Sales)/Sum(Total Sales))*100 ,'##,#0.##')& '%' &chr(10)&
'Total Sales=' & Sum(Sales),Sum(Sales))

displaying the pop up is

Country =USA

City=New york

Product:

101

102

103

% Gain =20 %

Total Sales = 10100

But I want to display in this way.

Country =USA

City=New york

Product:

101 ---4400 ---43.56 %

102 ---4770 ---47.22 %

103 ---930 ---9.2 %

% Gain =20 %

Total Sales = 10100

2.Scenario 2:

I have ID field, P_ID , M1...M5 Values (Yes, No) are there,

based on Id which is max count of yes in M1... M5 Tables,

i used rangemax( M1...M5 ) it will display the value,

But I want to display the column name also Like

ID MAX Value Field

101 15 M1

102 10 M1

ID	Max Value	Field
	25
101	15	M1
102	10	M1

I attached QVW file , Please help me .

Thanks

Re: In Bar graph show the Pop Up Message

rubenmarin — Sat, 23 May 2020 19:07:44 GMT

Hi, for scenario 1 you can use:

Dual(City & Chr(10)&'Product Codes :'&Chr(10)& Concat(Aggr(Product & ' --- ' & Sum(Sales) & ' --- ' & Num(Sum(Sales)/Sum(TOTAL <City> Sales),'#.00%') , City, Product) ,Chr(10))& Chr(10)& '% Gain='& Num((Sum(Sales)/Sum(Total Sales))*100 ,'##,#0.##')& '%' &chr(10)& 'Total Sales=' & Sum(Sales),Sum(Sales))

For scenario 2 I can only think on a nested if comparison, maybe there is a clever way than this.

Sample attached.

Re: In Bar graph show the Pop Up Message

Ramu — Tue, 26 May 2020 06:36:15 GMT

Hi Rubenmarin,

Thanks for your valuable suggestion.

It's working.

Thanks a Lot.