topic Re: How to filter out rows on straight table? in QlikView

How to filter out rows on straight table?

Wed, 12 Feb 2014 11:11:09 GMT

How do I filter out rows of data on a straight table? I can't figure out where to the set analysis

Basically i have a field Ideas.Status and i only want those with values of Delivered or Rejected shown

Re: How to filter out rows on straight table?

mazacini — Wed, 12 Feb 2014 11:30:55 GMT

Hi Alex

You can use Set Analysis in the expression in your straight table.

So for instance of you were summing the values of FieldName for dimension Ideas.Status, your expression would be Sum(FieldName), with Ideas.Status as your dimension

But to restrict, Sum({<Ideas.Status={'Delivered,Rejected'}>}FieldName)

Hope this helps.

Joe

Re: How to filter out rows on straight table?

marcus_sommer — Wed, 12 Feb 2014 11:31:36 GMT

Perhaps as dynamic dimension like if(match(Ideas.Status, 'Delivered', 'Rejected'), Ideas.Status) and then check on "hide Null-Values".

- Marcus

Re: How to filter out rows on straight table?

sujeetsingh — Wed, 12 Feb 2014 11:34:58 GMT

you can filter out by using some filters or some variables

Re: How to filter out rows on straight table?

Wed, 12 Feb 2014 12:15:25 GMT

This may be a silly question, but where do I enter the expression? There is no expression tab on the properties for a table box

Re: How to filter out rows on straight table?

Wed, 12 Feb 2014 12:16:08 GMT

cool. where exactly would i enter this though?

Re: How to filter out rows on straight table?

Wed, 12 Feb 2014 12:18:53 GMT

where are these filters though?

Re: How to filter out rows on straight table?

marcus_sommer — Wed, 12 Feb 2014 12:39:21 GMT

Re: How to filter out rows on straight table?

mazacini — Wed, 12 Feb 2014 12:41:50 GMT

Hi Alex

I picked you up wrong on the terminology.

You are using a table box, not a straight table (which is a chart type)

The table box simply lists the table entries for the field selections you make in the properties window.

If you simply want to list for Delivered and Rejected, just display the list box for Ideas.Status, and select the relevant values - your table box will only display for these selections.

Hold Ctrl button while clicking multiple entries in the list box to display associated data in your table box.

Joe

Re: How to filter out rows on straight table?

sudeepkm — Wed, 12 Feb 2014 12:43:58 GMT

Writing expressions is not available in a Table box Object. In Table box you can only enable Drop Down for your fields.

To use expressions (set analysis or any other expression), you need to create a Chart object > Straight Table.

Re: How to filter out rows on straight table?

Wed, 12 Feb 2014 12:59:23 GMT

Sorry, my fault. I was using the wrong terminology.

I will try with a Straight table instead then, as a table box doesn't seem to be able to filter out rows

Re: How to filter out rows on straight table?

richard — Wed, 12 Feb 2014 12:59:56 GMT

1) Use a straight table (charttype)

2) Select a dimension field

3) Edit that dimension to look like: if(match(Ideas.Status, 'Delivered','Rejected')>=1, FieldName)

4) Enable the field "Supress when value is null"