Only () for content of fields

[beck_bakytbek]

Hi Folks, i have the following data-structure,

Info,         Typ,      Sales,

ABC1,      FK          100

ABC2,      FK          150

ABC3,      EK          220

ABC4,      DK          180

if i want to know the sum of  Typ = FK , so then i am using: the set expression like

Sum({<Typ ={'FK'}>}Sales) and my result does look like > Sum of FK = 250 and it does work well,

my issue is, that i have a lot of data, and i want to know the content of fields , like Info

for example: Only(Sum({<Typ ={'FK'}>}Sales)) and i want to display the fields with Info: ABC1, ABC2 but it does not work.

Does anybody have any idea, how to show the content of fields of Info on the base of fields of Typ, Sales

Thanks a lot

Beck

[beck_bakytbek]

Chanty Thanks a lot for your feedback and help

[beck_bakytbek]

Devarasu Thanks a lot for your feedback and help

[beck_bakytbek]

Jonathan Thanks a lot for your feedback and help

[beck_bakytbek]

Ashwini Thanks a lot for your feedback and help

[devarasu07]

yes. just create your list box with calculated dimension then it should work as expected way. refer to the attached both qlikview/qliksense.

calculated dimension for the list box is

if(Typ='FK', info)

[beck_bakytbek]

Thanks a lot for your response and help