Discussion Board for collaboration related to QlikView App Development.
HI Team -
I have data set as below.
ID1 Status Date
1 Owned 8/10/2017
1 Leased 8/25/2017
2 Leased 9/10/2017
Here if ID1 is both Owned and Leased the I want to ignore the dates and if ID1 is Leased I want to show date.
If I put ID and Date in table box inly ID 2 should show date and ID should show blank for date.Is this doable ?
Thank yiu much.
Something like this?
Use a straight table with Dim: ID1
expression: = IF(Count(Status) > 1 AND Status = 'Leased', 0, DateValue)
Or This if you want to add the fields in your Table Box.
LOAD * INLINE [
ID1, Status , DateValue
1 , Owned , 8/10/2017
1 , Leased, 8/25/2017
2 , Leased, 9/10/2017
INNER JOIN (Table1)
IF(Count(Status) > 1, '-', 1) As NewCounter
Group By ID1;
LOAD ID1, Status, DateValue, IF(NewCounter = 1, DateValue) AS NewDate
Drop Table Table1;
Can you please share the qvw ? I am not getting the same output.