Filter and view data

[#1]

Hi,

I would like to view only certain data (in this example, where field1+field2 >= 40).  This is a straight table.

I have 3 fields in the data, serial#, field1 and field2. 

Calculated field has expression Calculated field = field1+field2. 

Visible has expression where if(field1+field2>=40, 'Y', 'N')

Serial#	Field1	Field2	Calculated Field	Visible
1	11	21	32	N
2	12	22	34	N
3	13	23	36	N
4	14	24	38	N
5	15	25	40	Y
6	16	26	42	Y
7	17	27	44	Y
8	18	28	46	Y

Qn1: 

How can i see the table in the following format?  Do i need to create another tabe?  do i have to do the calculated in expression tab, or general tab->expression?

Serial#	Field1	Field2	Calculated Field
5	15	25	40
6	16	26	42
7	17	27	44
8	18	28	46

Qn2:

How can i expression "visible" in 1st original table without reusing the formula, ie. if(field1+field2>=40, 'Y', 'N') or can i use if(column(4)>=40,'Y', 'N'))?

thanks!

[sujeetsingh]

Try to go with this sample

[#3]

I am using personal edition of qlikview... possible to elaborate in this forum? thanks,,,

[ariel_klien]

Hi,

i attached a file.

i hope this will help you.

BR

Ariel

[ariel_klien · Accepted solution]

hi,

1) create a chart > straight table

2) select dimensions Serial#,Field1,Field2

3) expression : =if(Field1+Field2>=40,Field1+Field2,null())

that will do it...

BR

Ariel

[#6]

Sorry, possible to elaborate in word, as i am using a personal edition of qlikview?

much appreciated.

[sujeetsingh]

Use expression as if(sum(Quantity)>3,sum(Quantity),Null())

[#8]

Thanks!

Can i also check, how can i use this table as a "selection box"?

Basically, i would like to select the values that are visible.  I have a large data, so it's difficult to select and scroll to the end.

[ariel_klien]

Hi

make another field in your LOAD :

Field1+Field2 as Calculated_Field

then you can do that

BR

Ariel

[sujeetsingh]

Hi,

At espresiion use as

If condition will give you only SUM(Field1)+Sum(Field2) greater than some value else null().