Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva8
Contributor
Contributor

qlik requirement

HI Team,

could you please help me out with the below requirement

input table :

product ,quantity

AC,2

TyV,3

EXPECTED OUTPUT AS BELOW:

product,quantity

AC,1

AC,1

TV,1

TV,1

TV,1

 

Thanks in advance

regards

siva 

 

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

Load
	product,
	1 as quantity
While IterNo() <=quantity;	

Load * Inline [
product ,quantity
AC,2
TV,3]

View solution in original post

7 Replies
tresesco
MVP
MVP

Try like:

Load
	product,
	1 as quantity
While IterNo() <=quantity;	

Load * Inline [
product ,quantity
AC,2
TV,3]
siva8
Contributor
Contributor
Author

HI Tresesco,

 

sorry for the late response

the above  mentioned  script working as per my requirement.

in table viewer  it showing as expected but when i Create a table box in front end its showing wrongly 

please find the below table viewer and table box screen shots

siva8_0-1592221170696.png

 

siva8_1-1592221318523.png

Thanks 

siva

 

Saravanan_Desingh

Table box shows only the unique values. But the records will be there. If you use Count(quality), you could see the count of records.

tresesco
MVP
MVP


@...

a table box in front end its showing wrongly 


No, table box is showing only the unique combination of records/rows and that is how it is designed. So don't worry about the number of records seeing in the table box. Do your calculations, it would work as expected. 

siva8
Contributor
Contributor
Author

Hi Tresesco,

thank you for your prompt response 

i understood the behavior of  table box , is there any way in qlik,  we can show in front end as we saw duplicate records in table viewer

thanks 

siva

Saravanan_Desingh

If you want to show the Duplicates, add RowNo() As RowID. Bring this in the Table

siva8
Contributor
Contributor
Author

Hi Saran,

thank you its working 

Thanks 

siva