Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
wiz_nerd
Creator
Creator

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
Labels (3)
6 Replies
lorenzoconforti
Specialist II
Specialist II

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?

wiz_nerd
Creator
Creator
Author

Hi Lorenzo,

Please check I have updated the desired table.

lorenzoconforti
Specialist II
Specialist II

Why are you not using Version as dimension?

wiz_nerd
Creator
Creator
Author

Because IDs are sort able and version is not.

uacg0009
Partner - Specialist
Partner - Specialist

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
Specialist II
Specialist II

Just sort Version by ID

Untitled.png