topic Re: dimension restriction in QlikView

dimension restriction

suvechha_b — Thu, 06 Aug 2015 14:16:27 GMT

How to restrict the pivot table value.

I want to show product whose item_no =2.

I want to restrict through dimension.

Re: dimension restriction

mishraamit2485 — Thu, 06 Aug 2015 14:19:36 GMT

You can use calculated dimension in dimension like, if(item_no='2',Yourresult,)

Re: dimension restriction

Kushal_Chawda — Thu, 06 Aug 2015 14:22:47 GMT

Create calculated dimension,

If( item_no=2, product). And check suppress NULL values option for this.

In your expression you can do something like below

sum({<item_no={2}>}Value)

Re: dimension restriction

Anonymous — Thu, 06 Aug 2015 14:24:04 GMT

The only way to do this would be to use set analysis - {Item_no = {2} - or a calculated dimension like Amit said. Be sure to hide null values for each dimension when you use calculated dimensions.

Re: dimension restriction

jonathandienst — Thu, 06 Aug 2015 14:25:22 GMT

Something like:

If(item_no = 2, product)

But for more accurate help, I suggest that you provide more information, and preferably your qvw application or a representative sample.

Re: dimension restriction

maximiliano_vel — Thu, 06 Aug 2015 14:30:23 GMT

Is this what you need?