topic Conditional Rows Straight table in QlikView

Conditional Rows Straight table

Sun, 06 Feb 2011 20:10:42 GMT

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

Conditional Rows Straight table

prieper — Sun, 06 Feb 2011 22:12:32 GMT

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

HTH
Peter

Conditional Rows Straight table

Sun, 06 Feb 2011 23:02:56 GMT

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

Conditional Rows Straight table

prieper — Mon, 07 Feb 2011 17:19:15 GMT

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

Conditional Rows Straight table

maneshkhottcpl — Tue, 08 Feb 2011 03:47:36 GMT

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.