Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help

I have a table like

Table1:

Rec_ID, KEY

1, A

1,B

1,C

1,D

1,E

I have another table where we have entries like

TABLE2:

KEY ,VAL(%), TYPE

A, 80, 1

B,60,1

C,20,2

D,0,0

I am able to show the result in pivot table for TYPE 1 as

KEY ,VAL(%)

A ,80

B,60

C,100

D,100

E,100

AVG: 88

Here in TABLE 2 i  have value for only A and B for type 1 and since there is no data for C,D and E in table 2 we have to consider 100 as default value and then show the average of all the percentages in the bottom. so basically i have to take the average of all the KEYs in table 1 and calculate. if KEY is available then take the value otherwise consider as 100 and calculate the average

Now the same average value of percentages  i need to calculate in gauge chart . So need help with expressions

2 Replies
Joaquin_Lazaro
Partner - Specialist II

Hi  binodkumar_22:

Read this Generating Missing Data In QlikView

and this JOIN sample

The first is a doc which expalains how to deal empty values, the second some sample of joining methods.

Hope it helps you

JoaquĆ­n

Not applicable
Author

Can you give one example with the above data for above scenario... i need to get average % in gauge meter