Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Display values in straight table

Hi,

i have a table with some product numbers and some other fields displayed in straight table.

i have to display three names consecutively across each product numbers. how will i do this? please help me with the expression

for example , if i have the names John, Abbie, Emma. My output should be like  below:

Product NoUsername
30494John
30677Abbie
31086Emma
31742John
40005Abbie
40726Emma
41675John
  

 

 

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: Display values in straight table

Something like:

if(RowNo()/2 = Floor(RowNo()/2).'Abbie'.
       if(RowNo()/3 = Floor(RowNo()/3).'Emma.'John')) as UserName;

 

View solution in original post

4 Replies
Highlighted
Master II
Master II

Re: Display values in straight table

Something like:

if(RowNo()/2 = Floor(RowNo()/2).'Abbie'.
       if(RowNo()/3 = Floor(RowNo()/3).'Emma.'John')) as UserName;

 

View solution in original post

Highlighted
Specialist II
Specialist II

Re: Display values in straight table

Could you please let me know how the input data will be 

Highlighted

Re: Display values in straight table

Your requirement is not clear , you are wanted to show customers/users for each product rite ? but in the example your product ID is different for all the users ..not user how your data looks like , could you share a sample data set and required output so that we could try to help 

Highlighted
Contributor III
Contributor III

Re: Display values in straight table

Thank you so much