How to Display associate values in Text Box

[#1]

Hi All,

Please find the below screenshot.

I have a list if fields like the above, when I select " sbutypename" it will be display in the text box. the four value which are showing in the activityid 327,328,329,331 are the associate value for the current selection.

With out selecting" activityid" value how can I display in the List box. Is it possible in Qlikview or not?

I used GetFieldselection(sbutypename,',') for the "text objects".

Please help me.

Thanks.

[#2]

Hi Sunny,

=If(GetSelectedCount(sbutypename) > 0, Concat(Distinct activityid,','))

This is working... Thanks for your help.

[sunny_talwar]

Not a problem.

I am glad I was able to help

Best,

Sunny

[#4]

Hi All I got that solution I want some more detailed information.

now I am able to get associated value. but I want a detailed report should be display then user can able to take print.

But I want little more descriptive way how would I get with respectively activityid detail report. user need to take a print in PDF format.

please check I want the out put like below,

When I select sbutypename associate activityid's are displaying, I want report for individual activityid's with respective sbutypename.

Thanks.

[jagan]

Hi,

Instead use a straight table and create dimension with concatenated dimensions & strings, there is no fixed number of Possible values it may vary based on selections so it is difficult.  This can be easily done in tabular format using straight table, by this you can export all values to excel if required, but by using Text object it is not possible.

Regards,

Jagan.

[#6]

Hi Jagan,

Can you have any sample QVW file, so please share it.

Note: My requirement is I want for each activityid all the information separately. I tried with crosstable. but I have lakhs of records, it is giving performance issue.

how to solve this can any one please tell me

Thanks,

Shanvaz

[qlikuser222]

HI all.

How to display only on; val;ye in the text box?

like when subtypename  consulting is selected we have associative values for Activity Id has 327,328,329 and 331.

Now how can we show first value of it in text box? i.e 327

Thanks