topic Filter and view data in QlikView

Filter and view data

Thu, 06 Jun 2013 06:37:58 GMT

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!

Re: Filter and view data

sujeetsingh — Thu, 06 Jun 2013 06:55:07 GMT

Try to go with this sample

Re: Filter and view data

Thu, 06 Jun 2013 06:57:30 GMT

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

Re: Filter and view data

ariel_klien — Thu, 06 Jun 2013 06:57:50 GMT

Hi,

i attached a file.

i hope this will help you.

Ariel

Re: Filter and view data

ariel_klien — Thu, 06 Jun 2013 07:00:52 GMT

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...

Ariel

Re: Filter and view data

Thu, 06 Jun 2013 07:01:14 GMT

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

much appreciated.

Re: Filter and view data

sujeetsingh — Thu, 06 Jun 2013 07:04:02 GMT

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

Re: Filter and view data

Thu, 06 Jun 2013 07:09:53 GMT

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.

Re: Filter and view data

ariel_klien — Thu, 06 Jun 2013 07:17:43 GMT

make another field in your LOAD :

Field1+Field2 as Calculated_Field

then you can do that

Ariel

Re: Filter and view data

sujeetsingh — Thu, 06 Jun 2013 08:16:22 GMT

Hi,

At espresiion use as

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

Re: Filter and view data

er_mohit — Thu, 06 Jun 2013 09:53:58 GMT

See the attached file