Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Ignoring more than one list boxes selections

Hi

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

1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

Ignoring more than one list boxes selections

it's the same:

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

4 Replies
erich_shiino
Honored Contributor

Ignoring more than one list boxes selections

it's the same:

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

Not applicable

Ignoring more than one list boxes selections

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

erich_shiino
Honored Contributor

Ignoring more than one list boxes selections

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

Not applicable

Ignoring more than one list boxes selections

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.

Community Browser