topic Re: Make conditional dimension in QlikView

Make conditional dimension

agni_gold — Fri, 23 Oct 2015 17:33:38 GMT

Hi All ,

I have a table in which only one column and this table is individual loaded in my data model , not link to any table ,

Field Name is ABC

And from my data model i have picked one dimension XYZ , i want to write in dimension

If (XYZ<>ABC,XYZ)

This is not working please explain why

sunny_talwar — Fri, 23 Oct 2015 17:43:21 GMT

Can you share a sample if possible?

Anonymous — Fri, 23 Oct 2015 17:55:47 GMT

Use RecNo() in both the table to assign a unique value and then try to do what you are looking at.

Example would be helpful for us to guide you properly in one go.

Fri, 23 Oct 2015 18:30:38 GMT

Try doing mapping load like this:

ABC_MAP:

Mapping Load

ABC,

From Datasource;

Main Table:

Load

if(XYZ_Temp = 1,XYZ) as XYZ

;

Load

XYZ

applymap('ABC_MAP',XYZ,null()) as XYZ_Temp

From Datasource2;