topic Re: Hide Particular Expression for a Dimension value in QlikView

Hide Particular Expression for a Dimension value

shanky1907 — Wed, 19 Oct 2016 11:17:53 GMT

Hello All,

I have a situation.

I have 4 Dimensions as A, B, C, D &

For Expression as W, X, Y, Z.

I have taken A,B,C horizontally and D vertically.

Now if D has three values a , b , c.

Now for c i only want to show expressions Y,Z.

How i can i achieve this in pivot chart?

Can anybody help?

Re: Hide Particular Expression for a Dimension value

sunny_talwar — Wed, 19 Oct 2016 11:47:12 GMT

You will need to use Pick(Match(...)) with synthetic dimension/island table field to accomplish this. If you can provide a sample of your raw data and your expected result, we might be able to help you better here

Re: Hide Particular Expression for a Dimension value

shanky1907 — Wed, 19 Oct 2016 12:01:00 GMT

Please find the Attached format which is required.

Re: Hide Particular Expression for a Dimension value

sunny_talwar — Wed, 19 Oct 2016 12:09:36 GMT

Where is the raw data . The Excel is all empty

Re: Hide Particular Expression for a Dimension value

Anonymous — Wed, 19 Oct 2016 12:10:58 GMT

Hi,

Please see attached.

Similar to what stalwar1‌ mentioned.

Each dimension has their own expression that is visible when a dimension is selected.

Re: Hide Particular Expression for a Dimension value

shanky1907 — Wed, 19 Oct 2016 12:11:29 GMT

The data can be anything... I just dont want to show Expression W & X for Dimension value c of Dimension D