topic Re: Hiding row data in table in QlikView

Hiding row data in table

Thu, 12 Feb 2015 13:15:52 GMT

I want to display a table with information, but I want to exclude all information where field1 <> 0 and in field2 does not have a value of say 'A'. Best would be set analysis but i want the values to change as other selections are done, those two fields though have to be constant and not include any other rows of data

The initial table already needs to only reflect data where field1 = 0 and field2 = 'A', even without selections being made

Any help would be greatly appreciated

Andre

Re: Hiding row data in table

Gysbert_Wassenaar — Thu, 12 Feb 2015 14:51:09 GMT

Perhaps something like this:

if(len(GetCurrentSelections()),count({$+<field1={0},field2={'A'}>}field3),count({$<field1={0},field2={'A'}>}field3))

Re: Hiding row data in table

Fri, 13 Feb 2015 05:23:57 GMT

This looks like something with dimensions and expressions

What I am looking for is the following. I have the four columns below in a table. I want to hard code the table to only show me records where [ExpectedConsumption]={0.000} and [MeterType]={'K'}. Can this be done a table? you also need to take into account selection made on other fields not showing here. There are no sums or counts in question, this is just an add on to this other question with detailed information as in thread 151794

Re: Hiding row data in table

Fri, 13 Feb 2015 06:22:46 GMT

andret

Just did this in my qlikview, one possible way if I understand ur query correctly, is to go to your presentation tab in your chart, then tick conditional for the fields you want to display. for example you can put field1 <> 0 and field2 <> 'A ', in both fields, this condition will work when you do your selection.

I hope this resolves it.

regards Dlamini

Re: Hiding row data in table

renjithpl — Fri, 13 Feb 2015 06:43:24 GMT

may be somthing like this

assuming this is a straight table with UnitDescription as dimension and below can be expressions..

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}ExpectedConsumption)
Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}MeterType)
Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}RegNo)

Re: Hiding row data in table

Fri, 13 Feb 2015 07:00:10 GMT

Tried this, added extra field, how do I handle the expression which I would not want to use

I added one extra column to show all 4 fields but one of them is not showing on the list of fields. Then no rows are showing probably because there is no Expressions, I can add one but then hide the column.

Ideally I would want to show this in a table box not a straight table, but if there is no other way around it the straight table would work, if I can add the hidden expression field

Re: Hiding row data in table

Fri, 13 Feb 2015 07:11:12 GMT

So I have

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}UnitDescription)

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}ExpectedConsumption)

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}MeterType)

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}RegNo)

All with enable Conditional - this is where the aove expressions are loaded, also added suppress when value is null on all, for some reason sum nulls are showing so I hid it, I also added an expression, just added a 1 and I hide the field. That works ok now but for some reason the ExpectedConsumption Column is just now showing,

Re: Hiding row data in table

Fri, 13 Feb 2015 07:13:44 GMT

Exactly what did you put into the conditional statement?

Re: Hiding row data in table

Fri, 13 Feb 2015 07:16:48 GMT

I added this in as the conditions where you said, does the same as Renjiths, the moment I add this for all 4 column the Expected consumption falls away

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}UnitDescription)

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}ExpectedConsumption)

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}MeterType)

Only({<[ExpectedConsumption]={0.000}, [MeterType]={'K'} >}RegNo)

Re: Hiding row data in table

Fri, 13 Feb 2015 07:27:08 GMT

Andret

If possible, can you send me a sample doc, I wil recreate da qvd file, den send it to you.

Re: Hiding row data in table

Tue, 17 Feb 2015 09:41:21 GMT

Attached is some sample data

Re: Hiding row data in table

Tue, 17 Feb 2015 12:43:42 GMT

Maybe the way forward is to flag the fields in the original import