topic Re: Display values in straight table in QlikView

Display values in straight table

prrajendran — Sat, 16 Nov 2024 19:13:36 GMT

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 No	Username
30494	John
30677	Abbie
31086	Emma
31742	John
40005	Abbie
40726	Emma
41675	John

Re: Display values in straight table

m_woolf — Mon, 27 Jan 2020 20:23:12 GMT

Something like:

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

Re: Display values in straight table

anushree1 — Tue, 28 Jan 2020 05:31:40 GMT

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

Re: Display values in straight table

avinashelite — Tue, 28 Jan 2020 06:05:54 GMT

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

Re: Display values in straight table

prrajendran — Tue, 28 Jan 2020 09:24:18 GMT

Thank you so much