topic Re: PIVOT Help - Data Presentaion in QlikView

PIVOT Help - Data Presentaion

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

HI All,

I need a quick help in presenting data in Pivot table.

MOCID	StoreCode	Status
1	1	C
2	1	NC
3	1	NA
4	1	C
5	1	C
1	2	C
2	2	NC
3	2	NA
4	2	C
5	2	C
1	3	C
2	3	NC
3	4	NA
4	4	C
5	4	C
1	5	C
2	5	NC
3	5	NA
4	5	C
5	6	C

With PIVOT table I can present the data as :

StoreCode	MOCID	1	2	3	4	5
1		C	NC	NA	C	C
2		C	NC	NA	C	C
3		C	NC	-	-	-
4		-	-	NA	C	C
5		C	NC	NA	C	-
6		-	-	-	-	C

My requirement is to present only the history of different MOCIDs for stores appearing in current MOCID. If I assume MOCID 5 is my present MOC - I need to present only data of StoreCode 1, 2, 4 and 6.

Can someone explain how can I get rid of other StoreCode not appearing in current MOCID?

See attached sample data qvw.

Regards,

Re: PIVOT Help - Data Presentaion

sunny_talwar — Mon, 29 Jan 2018 13:19:07 GMT

Not sure I completely understand... what is the expected output you are looking to get?

Re: PIVOT Help - Data Presentaion

tahirkhalil — Mon, 29 Jan 2018 13:23:09 GMT

Hi Sunny,

I want to include only those storecode which are part of current MOCID i.e. 5

StoreCode	MOCID	1	2	3	4	5
1		C	NC	NA	C	C
2		C	NC	NA	C	C
4		-	-	NA	C	C
6		-	-	-	-	C

I just want to ignore the ones that are not the part of current MOCID.

Re: PIVOT Help - Data Presentaion

sunny_talwar — Mon, 29 Jan 2018 13:25:25 GMT

Try this

=maxString({<MOCID, StoreCode = p(StoreCode)>} Status)

Re: PIVOT Help - Data Presentaion

tahirkhalil — Mon, 29 Jan 2018 13:27:29 GMT

Yes ! Its working fine.

Thanks Sunny