topic Re: qlik requirement in QlikView

qlik requirement

siva8 — Wed, 25 Nov 2020 16:16:04 GMT

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

TV,1

Thanks in advance

regards

siva

Re: qlik requirement

tresB — Tue, 09 Jun 2020 09:48:50 GMT

Try like:

Load product, 1 as quantity While IterNo() <=quantity; Load * Inline [ product ,quantity AC,2 TV,3]

Re: qlik requirement

siva8 — Mon, 15 Jun 2020 11:42:52 GMT

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

Thanks

siva

Re: qlik requirement

Saravanan_Desingh — Mon, 15 Jun 2020 13:38:43 GMT

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.

Re: qlik requirement

tresB — Mon, 15 Jun 2020 13:42:40 GMT

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

Re: qlik requirement

siva8 — Mon, 15 Jun 2020 15:21:42 GMT

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

Re: qlik requirement

Saravanan_Desingh — Mon, 15 Jun 2020 15:23:47 GMT

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

Re: qlik requirement

siva8 — Mon, 15 Jun 2020 15:28:29 GMT

Hi Saran,

thank you its working

Thanks

siva