- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you give one example with the above data for above scenario... i need to get average % in gauge meter