could you please help me out with the below requirement
input table :
EXPECTED OUTPUT AS BELOW:
Thanks in advance
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
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.
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