This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have the following customer data
I need to send a letter to everyone with details of all of their accounts so what I’d like to do is have everything for each customer on one line. So for example
Account 1 #
Open date 1
Account 2 #
Open date 2
Account 3 #
Open date 3
Is there a clever way that Qlikview can identify that a customer for example has three accounts and put them side by side in a table? Displaying them as columns rather than rows?
I’ve used the following in the past
=if(count(distinct([Account #]))>1,subfield(concat(distinct([Account #]),',',),',',1),)
This works fine if you only want to display just the account numbers because it looks up distinct values but it doesn’t pull through their respective open dates.
Can anyone help?
May be this?
I used the script to create a new field...
AutoNumber(RowNo(), Name) as Count,
(html, codepage is 1252, embedded labels, table is @1);
Used Count as a pivoted dimension
View solution in original post
Genius thank you very much