topic Re: Display multiple fields in a list in QlikView

Display multiple fields in a list

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Difficult to explain this clearly I'm afriad.

We have several fields (up to six) in our data records that may need to be accessed if a single record is selected. These are free-text fields and may be quite long (hundreds of characters) or they may be blank. I'd like to have it appear a bit like an Access form. So if the data looks something like this (although there are a lot more fields I'm not including here)...

Date	Time	ID	Comment 1	Comment 2	Comment 3	Comment 4	Comment 5
1/2/17	08:34	170130a	This is the first comment on this event	This event has another comment that is longer than the first one, it is however the last comment for this event.
1/2/17	10:48	170201b	Nil
2/2/17	06:12	170202a	This event has several longer comments	This one is short	But this one is longer and still should be displayed fully without having to scroll the window	This event even had more comments that were entered in this field	This is the last comment for this event.
2/2/17	13:52	170202b
2/2/17	21:27	170202c	Only the one comment here

What we'd like to be able to do is select an ID, or group of (very few) IDs in another table and have displayed something like (in a separate sheet object):

Header 1	Header 2
ID	Comment 1 (if exists)
	Comment 2 (if exists) This event has another comment that is longer than the first one, it is however the last comment for this event.
	Comment 3 (if exists) This is the first comment on this event
	Comment 4 (if exists)
	Comment 5 (if exists)
	Comment 6 (if exists)
ID	Comment 1 (if exists)
	Comment 2 (if exists)
...	...

I'd just like to know if anyone has any ideas on how to accomplish this lower table (or similar) elegantly?

Thank you!

Re: Display multiple fields in a list

adamdavi3s — Thu, 09 Mar 2017 10:39:12 GMT

Christine,

Can you not just make up your lower table using a pivot? No ignore me that is dumb

Re: Display multiple fields in a list

Anonymous — Thu, 09 Mar 2017 10:42:33 GMT

Possibly, I'll look into it. Just that I'm really rubbish at pivots still.

Re: Display multiple fields in a list

adamdavi3s — Thu, 09 Mar 2017 10:45:12 GMT

I've got this far, just need to work out how to suppress missing values for you

Re: Display multiple fields in a list

adamdavi3s — Thu, 09 Mar 2017 10:46:47 GMT

Ok check this out

Re: Display multiple fields in a list

Anonymous — Thu, 09 Mar 2017 11:06:42 GMT

Thank you Adam. I just need to do some work on it presentationally, but that seems to fit the requirement!

Cheers!

Re: Display multiple fields in a list

adamdavi3s — Thu, 09 Mar 2017 11:08:45 GMT

No worries at all, you can use shorter fieldnames in the valuelist formula and the expression if you wanted to hide them a bit (e.g. just use 1,2,3,4)

Alternatively if you use a straight table you can just totally hide the calculated dimension but it doesn't look quite as neat

Re: Display multiple fields in a list

Anonymous — Thu, 09 Mar 2017 11:13:51 GMT

It would be nice if I could figure out how to make the comment column go multi-line if necessary, but can't have everything I guess.

Re: Display multiple fields in a list

adamdavi3s — Thu, 09 Mar 2017 11:19:18 GMT

Presentation > wrap cell text 😉

Re: Display multiple fields in a list

Anonymous — Thu, 09 Mar 2017 11:21:21 GMT

Yes, but they all go to the same height, even if they're empty

Re: Display multiple fields in a list

adamdavi3s — Thu, 09 Mar 2017 11:40:37 GMT

Hmmm true, how does yours look? This is about as tidy as I can make it I think, but obviously i've only got a limited dataset to work with

Re: Display multiple fields in a list

Anonymous — Thu, 09 Mar 2017 12:11:15 GMT

Adam, Sorry it took me a bit to edit the actual text and I've had to replicate what I'm seeing in a spreadsheet.

ID		Comments
150402u	Comment 1	No file found.
150402u	Comment 2	This was quite a long comment that I've edited a bit because it refers to personal information about a customer so I've shortened it but it actually needs to have a height of 4 lines to accommodate all the text
150402u	Comment 3	Initial period extended by head and further extension approved by the S/L
150402u	Comment 4	Recommend those things are in the standard bags (to cover special events) and in Special Event bag.
150402u	Comment 5	Fuel report carried out - form completed.