Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
noobie_wiz
New Contributor III

Using one field as key dimension and but show values from other field

I am using ID field as dimension but I want to

show the value of Version.

 I want all the results except null values.

IDVersionxy
1abc_1211
2 22
3abc_1433
4abc_1544
5abc_1655
6 66
7abc_1877
8abc_1988
9abc_2099

 

Version as dimension based on ID Desired table

Versionxy
abc_1211
abc_1433
abc_1544
abc_1655
abc_1877
abc_1988
abc_2099
6 Replies
lorenzoconforti
Contributor III

Re: Using one field as key dimension and but show values from other field

Not sure I understand 100% what you are trying to achieve but possibly you could use this an expression? 

Only(Version)

What is your desired final table?

noobie_wiz
New Contributor III

Re: Using one field as key dimension and but show values from other field

Hi Lorenzo,

Please check I have updated the desired table.

lorenzoconforti
Contributor III

Re: Using one field as key dimension and but show values from other field

Why are you not using Version as dimension?

noobie_wiz
New Contributor III

Re: Using one field as key dimension and but show values from other field

Because IDs are sort able and version is not.

Partner
Partner

Re: Using one field as key dimension and but show values from other field

Hi,
If you create a table box, and put "Version", "x" and "y" column into this table box,
is that what you want?
Aiolos Zhao
lorenzoconforti
Contributor III

Re: Using one field as key dimension and but show values from other field

Just sort Version by ID

Untitled.png