Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Hiding row data in table

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Hiding row data in table

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

11 Replies
MVP & Luminary
MVP & Luminary

Re: Hiding row data in table

Perhaps something like this:

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


talk is cheap, supply exceeds demand
Not applicable

Re: Hiding row data in table

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

Capture.PNG

Not applicable

Re: Hiding row data in table

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
Valued Contributor

Re: Hiding row data in table

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)

Not applicable

Re: Hiding row data in table

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

Not applicable

Re: Hiding row data in table

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,

Not applicable

Re: Hiding row data in table

Exactly what did you put into the conditional statement?

Not applicable

Re: Hiding row data in table

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)

Not applicable

Re: Hiding row data in table

Andret

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