topic Re: How to Display associate values in Text Box in QlikView

How to Display associate values in Text Box

Wed, 07 Oct 2015 05:00:39 GMT

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.

Re: How to Display associate values in Text Box

sunny_talwar — Wed, 07 Oct 2015 05:36:31 GMT

Have you tried GetFieldSelections() for activityid also?

=GetFieldSelections(activityid, ', ')

=Concat(Distinct activityid, ', ')

Re: How to Display associate values in Text Box

sunny_talwar — Wed, 07 Oct 2015 05:37:18 GMT

Re: How to Display associate values in Text Box

PrashantSangle — Wed, 07 Oct 2015 05:47:34 GMT

Hi,

GetFieldSelection() work only if you select in field

Concat() will definately work.

Regards

Re: How to Display associate values in Text Box

sunny_talwar — Wed, 07 Oct 2015 05:52:50 GMT

Good catch

Sorry for the misleading information

Best,

Sunny

Re: How to Display associate values in Text Box

Wed, 07 Oct 2015 05:55:17 GMT

Hi Sunny,

Thank you for your help,

=Concat(Distinct activityid,',) is working.

I tried "=GetFieldSelections(activityid,',') ", when I selected any value in the activityid list then only it will display otherwise it will be blank.

A small change, if I use =Concat(Distinct activityid,',) in activityid all values are displaying default

is there any way when I select a particular value in sbutypename then only activityid will be display otherwise it will be blank.

Thanks.

Re: How to Display associate values in Text Box

tresB — Wed, 07 Oct 2015 05:56:03 GMT

And concat() would not work if only the selection has to be considered.

Re: How to Display associate values in Text Box

sunny_talwar — Wed, 07 Oct 2015 05:56:32 GMT

You can try this:

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

Re: How to Display associate values in Text Box

jagan — Wed, 07 Oct 2015 06:00:07 GMT

Hi,

Try

=Concat(DISTINCT activityid , ',')

Hope this helps you.

Regards,

Jagan.

Re: How to Display associate values in Text Box

Digvijay_Singh — Wed, 07 Oct 2015 06:01:35 GMT

You can try like this -

=Concat({<Product=P(Product)>}Product,',')

Re: How to Display associate values in Text Box

Wed, 07 Oct 2015 06:09:09 GMT

Hi Sunny,

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

This is working... Thanks for your help.

Re: How to Display associate values in Text Box

sunny_talwar — Wed, 07 Oct 2015 06:10:45 GMT

Not a problem.

I am glad I was able to help

Best,

Sunny

Re: How to Display associate values in Text Box

Wed, 14 Oct 2015 10:46:17 GMT

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.

Re: How to Display associate values in Text Box

jagan — Wed, 14 Oct 2015 13:59:19 GMT

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.

Re: How to Display associate values in Text Box

Fri, 16 Oct 2015 07:30:49 GMT

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

Re: How to Display associate values in Text Box

qlikuser222 — Mon, 11 Feb 2019 20:53:51 GMT

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