Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Try to go with this sample
I am using personal edition of qlikview... possible to elaborate in this forum? thanks,,,
Hi,
i attached a file.
i hope this will help you.
BR
Ariel
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
Sorry, possible to elaborate in word, as i am using a personal edition of qlikview?
much appreciated.
Use expression as if(sum(Quantity)>3,sum(Quantity),Null())
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.
Hi
make another field in your LOAD :
Field1+Field2 as Calculated_Field
then you can do that
BR
Ariel
Hi,
At espresiion use as
If condition will give you only SUM(Field1)+Sum(Field2) greater than some value else null().