topic Re: 3 Line Graphs-Conditional Display as per Input in QlikView

3 Line Graphs-Conditional Display as per Input

Mon, 26 Jan 2026 16:26:21 GMT

Hi Expert ,

Here you can see 3 line graphs when Call Type field is blank.

Now the Call type may have 3 values (Project , Request and Problem)My requirement is to display the lines basis of Call Type selection .

Example :

If user select Call_Type as Problem, then only red graph should display

If user select 2 Call_Type i.e. Project and Request call type then Only green and yellow line should display

and so on.

Kindly help .Advance Thanks.

Re: 3 Line Graphs-Conditional Display as per Input

tresB — Wed, 11 Jun 2014 10:13:13 GMT

Conditional expression should be something like:

=SubStringCount(Concat(Distinct [Call Type], ',') , 'Problem') // for expression related to problem

and similarly for other expressions.

Update: Corrected

Re: 3 Line Graphs-Conditional Display as per Input

senpradip007 — Wed, 11 Jun 2014 10:14:07 GMT

If you want that features use the following expressions as conditional on and off in Expressions Tab.

Call_Type = 'Project'

Call_Type = 'Request'

Call_Type = 'Problem'

Re: 3 Line Graphs-Conditional Display as per Input

Wed, 11 Jun 2014 11:23:24 GMT

Hi,

Thanks for your prompt reply and help.

Please let me know what will be the expression if user will select two Call_TYPE i.e. Project and Request to display green(Project) and Yellow(Request line only) and to remove red(Problem) line from the graph.

Thanks,

Rahul

Re: 3 Line Graphs-Conditional Display as per Input

Wed, 11 Jun 2014 11:24:00 GMT

Hi Pradeep,

Thanks for your suggestion.

Thanks,

Rahul

Re: 3 Line Graphs-Conditional Display as per Input

tresB — Wed, 11 Jun 2014 11:29:49 GMT

Have you tried the expression with SubStringCount() as I have shown above?

Re: 3 Line Graphs-Conditional Display as per Input

Wed, 11 Jun 2014 11:44:29 GMT

Thanks a lot....Its working fine .

Appreciate your effort

Re: 3 Line Graphs-Conditional Display as per Input

Thu, 12 Jun 2014 10:28:00 GMT

Hi Tresesco,

First I want to say thanks for your previous help again .

Now I have one more issue remain .Below is the expected output when user select Call Type as 'PROBLEM' and Support Group as ADM.

But here it’s coming like below and you can see the Y axis has very different value from above

Below is the code what I have written as script form PROBLEM (similarly for Request and Project)

LOAD
Ticket_ID as Ticket_ID_proj,
floor(Create_Date) as [Generic Date],
WeekName(date(num#([Create_Date]),'M/DD/YYYY'),0,-1) as [Generic Week],
MonthsName(1,date(num#([Create_Date]),'M/DD/YYYY')) as [Generic Month],
'Created Date' as DateType
FROM
..\DATA\VisualFactory\LogCall.qvd
(qvd)
where Call_Type = 'PROBLEM';

And here is the expression which I am using to display PROBLEM Graph

Similarly Graph is not showing the correct values when selecting one or two call type.

Please help. Thanks in Advance

Best Regards,

Rahul Pathak