Conditional Rows Straight table

[#1]

Hi there,

I am very new to qlikview and i m working on a set of client data.

Basically all clients have an EndDate field - if that field is blank they are an active client - if they are inactive thi field contains a date

I only want to display clients that are active

My original dimension is the clientID and I have added a the endate field as the last column

I have tried setting the enddate to 0 hoping suppress o values would lose the row but it does not instead the row still appears with a zero in this field

I considered a conditional load however as there are old transactions in the data model there is a relationship with inactive clients and i may want to use that later

any suggestions would be appreciated

thanks

[prieper]

One possibility might be to have a calculated dimension, similar condition might as well be part of the expression

HTH
Peter

[#3]

thank you - did not think of doing it that way - would not have either!

Thanks

One more question now... so i have a calculated dimesipon now and I have created a list box to filter using the same expression - is that the right way forward....my list box does not eem to filter too well but i suspect a data issue so just checking

[prieper]

If you need this more regularly, would add one more (boolean) field in the script already, in which you check, wether there is a data or not.
This will make further filtering etc. much more easy

HTH
Peter

[maneshkhottcpl]

Hi

U can also use the script at loading the table like

If (isnull(dateFiled)<>-1,IDField) as NewIDFiled

the NewID Filed u can use in list box which will avoid of calculation in frontend.