Please help with logic

[priya945]

HI All,

I am new to qlikview, please help with the logic to get same format in qlikview UI

Name	Jan			Feb
Name	W1	w2	w3	W1	w2	w3
suresh	5	10	7	6	7	8
Ram	4	6	8	9	8	7
Rahim	7	5	4	6	5	4

[Anil_Babu_Samineni]

Create Pivot Table and use Dimension as Name, Month and Week

Measure is Count(Measure)

Then, Transpose using Mouse from column to Row for Month and same as Week..

[priya945]

Thanks Anil