topic Ignoring more than one list boxes selections in QlikView

Ignoring more than one list boxes selections

Fri, 13 May 2011 01:51:40 GMT

How would you alter the expression to ignore more than one list boxes selections. For example I already have ignored one selection (express) in this expression belo by writing nothing after dimension name

=min({< sub_metrics = {'same day'},branch_flag ={'0'},express=>}target)

Now I also want to ignore Month dimension in the expression above. How would I change this expression to ignore Month along with express dimension?

Thanks in advance for any help.

Amey

Ignoring more than one list boxes selections

erichshiino — Fri, 13 May 2011 02:25:10 GMT

it's the same:

=min({< sub_metrics = {'same day'},branch_flag ={'0'},express= , month = >}target)

Ignoring more than one list boxes selections

Fri, 13 May 2011 14:30:45 GMT

Erich - thanks for your reply. I tried doing that but it's giving me syntax error near comma between express = and month =

Any idea?

Thanks,

Amey

Ignoring more than one list boxes selections

erichshiino — Fri, 13 May 2011 14:34:05 GMT

but does it not give you the results? Syntax checker can not recognized some script commands (try noconcatenate for example) and some set analysis structures.

You can send some app with dummy data, we can write the expression on the .qwvw

Regards,

Erich

Ignoring more than one list boxes selections

Fri, 13 May 2011 17:05:09 GMT

Thanks Erich. Unfortunately after getting syntax error I didn't go further. but I tried again now and it worked. Thanks again for your reply.