Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to limit a straight table to only show one record set of data

I need to know how to limit/manipulate a straight table to only show the data when user specifically select one product.

Let me explain further:

I have 2 listboxes. One contains Scenarios and the other one contains Products. One scenario can have one or more products.

I have a pivot table that lists all the metrics related to that product. Dimensions are scenarios, metrics and the product. I have the value of each metric as my expression. So, basically the presentation is: I have the metrics are rows, while I have Scenarios and Product as columns.

I have straight table which contains the materical cost of the product.

Now, this is my dilemna:

I need this material cost straight table to only show the data when a user specifically select one product only. So, if user select a scenario and that scenario has more than one product, the pivot table will display as usual (display all the products related to the scenario) but the material cost table will be emtpy until the user select one product only. Since the material cost is supposed to display the data of one product only.

I'm quite new to qlikview so I'm struggling how to do this. Any help/advice is greatly appreciated.

Thanks a lot.

1 Solution

Accepted Solutions
kaushik_solanki
Not applicable

Re: How to limit a straight table to only show one record set of data

Hi,

     All you need to do is, go to properties of your straight table.

     General Tab -> In Calculation Condition, type below expression.

     =if(getselectedcount(PRODUCT)=1,1,0)

     What this expression will do is, allow to render chart only if single value is selected from Product Field.

      Hope this is what you want.

Regards,

Kaushik Solanki

2 Replies
kaushik_solanki
Not applicable

Re: How to limit a straight table to only show one record set of data

Hi,

     All you need to do is, go to properties of your straight table.

     General Tab -> In Calculation Condition, type below expression.

     =if(getselectedcount(PRODUCT)=1,1,0)

     What this expression will do is, allow to render chart only if single value is selected from Product Field.

      Hope this is what you want.

Regards,

Kaushik Solanki

Not applicable

Re: How to limit a straight table to only show one record set of data

thanks a lot! this is exactly what i need.

i really need to familiarize my self with those built-in qlikview functions :-)

thanks again! :-)