topic Re: PivotTable in QlikView

PivotTable

Tue, 17 Jun 2014 04:06:06 GMT

Hi Guyz,

please find the attached qvw file.

from the above pivot table i dont want to display 0-15 data of BMSS and BOMSS& ZSTK of BSS.

Please help me in this context

Thank

REgards

Sampath botla

amit_saini — Tue, 17 Jun 2014 04:27:57 GMT

Hi Sampath,

Try this:

Data:

LOAD Catergory1,

Catergory2,

Exec_Date,

Qty

FROM

DATA.xlsx

(ooxml, embedded labels, table is Sheet1)

where BSS<>ZSTK and BSS <> BOMSS;

if it works , apply same for BMSS.

Thanks,
AS

felipe_dutra — Tue, 17 Jun 2014 04:29:24 GMT

Hi,

I do not understand why you created an expression for each category 1, one could use the existing dimension.

See the example.

Felipe

eduardo_sommer — Tue, 17 Jun 2014 04:29:42 GMT

Create a Pivot Table with 3 dimensions (Catergory1, Catergory2, Exec_Date), and the following expression:

sum({$<Catergory1={'BMSS'},Catergory2={'0-15'}> + <Catergory1={'BSS'},Catergory1=-{'0-15'}>} Qty)

You can see this in the attached file

Eduardo

dharmarasu — Tue, 17 Jun 2014 04:47:28 GMT

Hope this helps...

find in attachments

Dharma