Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
Contributor
Contributor

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

 

Highlighted
Specialist III
Specialist III

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.

Highlighted
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. 

Highlighted
Contributor
Contributor

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

Highlighted
Specialist III
Specialist III

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

Highlighted
Contributor
Contributor

Hi Saran,

thank you its working 

Thanks 

siva