Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How we can access particular data values from the tables of qvd files

Hello frns,

I am getting a problem in accessing particular data from the tables of qvd files for making charts.

Actually I have the relevant data not in the form of columns but in the in a kind of record itlself.,

Example:

A TABLE                                   B TABLE
A1col          A2col               A2col     A3col          A4col

B1               20                    20          C1          100

B2               30                    30          C2          200

B3               40                    40          C3          300

B4               50                    50          C4           400

B5               60                    60          C5          500

so if want to make a straight table chart say whose dimension is some values of A1col and whose expression can be calculated by using another table (B table using A4col) .

please help what will be the right expression for choosing values for dimesion B2,B4,B5 only.

3 Replies
Clever_Anjos
Employee
Employee

SUM({<A1col={"B2","B4","B5"}>}A4col)


Please don´t open two questions with same content

saumyashah90
Specialist
Specialist

Hey poornima,

In Dimension A1col and A2Col,

In Expression if(GetFieldSelection(A1col)=B2 or getFieldSelection(A1col)=B3
or GetFieldSelection(A1col)=B5,A4col)

Not applicable
Author

ok thanks, i will take care of it..