Discussion board where members can get started with QlikView.
below is the input data:
and below is the required output:
I managed to achieve this via Cross Table and later Pivot table in frontend. But as per requirement I am supposed to get this in Scripts. How can I reach to the required out put in scripts?
this is the result