topic Re: Text object Display. in QlikView

Text object Display.

Wed, 25 Nov 2020 16:16:04 GMT

I have data as below.

ID Notes EndDate

1 ABC 9/21/2016

1 AAA 7/22/2016

2 BBB 2/4/2016

I want to display in text object notes and Date together when ID is selected.So I have the below expression in text object.

=If(GetSelectedCount([ID]) > 0, DATE(EndDate) & ' - ' & Note)

This is displaying only one row of data for ID 1 where I want to show 2 rows of data for ID 1 in text box.How can I do that ?

neelamsaroha157 — Wed, 21 Sep 2016 12:44:20 GMT

Instead of doing this in Text object, try it with straight table and you can always change the look and feel of it as text object.

Something like this

Anil_Babu_Samineni — Wed, 21 Sep 2016 12:44:30 GMT

Let's Assume

if you select ID = 1 Then what are you expecting from Text object?

sunny_talwar — Wed, 21 Sep 2016 12:48:28 GMT

Are you sure you want to use text box object for this. If you do, may be try this:

=If(GetSelectedCount([ID]) > 0, Concat(Date(EndDate) & ' - ' & Notes, Chr(10)))

susovan — Wed, 21 Sep 2016 12:49:18 GMT

I know that its not a proper way.

But you can also try this attachment

Anonymous — Wed, 21 Sep 2016 12:51:25 GMT

you may use

=If(GetSelectedCount([ID]) > 0, concat(DATE(EndDate) & ' - ' & Note,chr(13))

but the best solution as neelam said use a straight table

sunny_talwar — Wed, 21 Sep 2016 12:56:24 GMT

Minor error in the expression. Here is the updated expression:

=If(GetSelectedCount([ID]) > 0, Concat(Date(EndDate) & ' - ' & Notes, Chr(10)))

Anonymous — Wed, 21 Sep 2016 12:56:51 GMT

Please find attached

Hope it help!!