Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Alternate states\Set analysis - wrong display in graph

Good day,

Still busy with alternate states: (See model attached)

I need:

    When I select two customers, there must be 2 lines on the graph,

    When I select one customer, there must be 1 line on the graph,

    When I select no customers, there must be 0 lines on the graph

But

I Get:

   When I select no customers, the total displays,

   When I select one customer, the total and that one customer display on the graph instead of only the   one customer.

   The only correct display at this stage is when I select 2 customers, this is confusing to clients.

Please help if there is a way to fix this.

Thanks a lot.

1 Solution

Accepted Solutions
MVP
MVP

Re: Alternate states\Set analysis - wrong display in graph

Hi

How's this? See the attached

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
3 Replies
MVP
MVP

Re: Alternate states\Set analysis - wrong display in graph

Hi

How's this? See the attached

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Alternate states\Set analysis - wrong display in graph

Thats awesome, thanks a lot

padmanabhan_ram
Contributor II

Re: Alternate states\Set analysis - wrong display in graph

create a rowno() i the graph table and in the customer put a condition if(customer='0', rowno()=null(),if(customer='1',rowno()='1',if(customer='2', rowno()='<=1 & >=2')))

give appropriate else part that is required for the graph.

hope this helps

Community Browser