Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

In Bar graph show the Pop Up Message

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  

2 Replies
Highlighted

Re: In Bar graph show the Pop Up Message

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.

Highlighted
Contributor
Contributor

Re: In Bar graph show the Pop Up Message

Hi Rubenmarin,

 

Thanks for your valuable suggestion.

It's working.

 

Thanks a Lot.