Hiding row data in table

[#1]

Hi

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

[Gysbert_Wassenaar]

Perhaps something like this:

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

[#3]

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

[#4]

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

[renjithpl]

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)

[#6]

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

[#7]

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,

[#8]

Exactly what did you put into the conditional statement?

[#9]

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)

[#10]

Andret

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