Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

PivotTable

Hi Guyz,

please find the attached qvw file.

Capture.PNG

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

1 Solution

Accepted Solutions
eduardo_sommer
Partner - Specialist
Partner - Specialist

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

View solution in original post

4 Replies
amit_saini
Master III
Master III

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
Partner - Creator
Partner - Creator

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
Partner - Specialist
Partner - Specialist

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
Creator
Creator

Hi

Hope this helps...

find in attachments

Dharma