topic Need help in QlikView

Need help

Tue, 26 May 2015 10:16:02 GMT

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

Re: Need help

Joaquin_Lazaro — Tue, 26 May 2015 10:46:54 GMT

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

Re: Need help

Tue, 26 May 2015 12:05:11 GMT

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