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

Alternate states\Set analysis - wrong display in graph

Fri, 26 Jul 2013 06:38:13 GMT

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.

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

jonathandienst — Fri, 26 Jul 2013 07:24:08 GMT

How's this? See the attached

Hope that helps

Jonathan

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

Fri, 26 Jul 2013 07:30:55 GMT

Thats awesome, thanks a lot

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

padmanabhan_ram — Fri, 26 Jul 2013 07:34:50 GMT

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