Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
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