Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner - Champion III
Partner - Champion III

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

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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
Author

Thats awesome, thanks a lot

padmanabhan_ram
Creator II
Creator II

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