Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
suvechha_b
Contributor III

dimension restriction

How to restrict the pivot table value.

I want to show product whose item_no =2.

I want to restrict through dimension.

5 Replies
mishraamit2485
Contributor

Re: dimension restriction

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

Re: dimension restriction

Create calculated dimension,

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

or

In your expression you can do something like below

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

napac1458
Contributor II

Re: dimension restriction

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.

MVP
MVP

Re: dimension restriction

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Partner
Partner

Re: dimension restriction

Is this what you need?