straight table dimensions- mix of query + synthetic

sonikajain — Wed, 02 May 2012 12:35:02 GMT

Hi all,

I am stuck in a problem where , in a table, few of the dimensions come from the load script (column in the data base) , and few are added synthetically (using valuelist/inline).

For example, in the table below, the ones highlighted in yellow are the ones that come from the database,the values

and the ones in blue are the ones that are to be generated synthetically. The calculation of these columns also have a different calculation for each row, far dissimilar to the ones in yellow, which get populated through a same calculation.

dimensions	Value1	Value2	Value3
allowed expense
netpaid expense
cost sharing
difference
allocated amount
Avg membership

Please Please help me on this.

Thanks in advance.

Sonika

straight table dimensions- mix of query + synthetic

sonikajain — Thu, 03 May 2012 10:27:29 GMT

Please guide me on this

straight table dimensions- mix of query + synthetic

azimabadi — Wed, 23 May 2012 13:38:54 GMT

Hi,

can you attach a sample qvw of your problem?

topic straight table dimensions- mix of query + synthetic in QlikView

straight table dimensions- mix of query + synthetic

straight table dimensions- mix of query + synthetic

straight table dimensions- mix of query + synthetic