topic How to write filter condition in Bar and Line graph? in QlikView

How to write filter condition in Bar and Line graph?

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have created the visual as shown below

How Can I filter my Value (Line Axis) expression?

My query logic is

Case when Report_Param = 'Sales' and Header_1 = 'Budget' and Header_2 = 'UDT' then sum(Value)

else 0

end as Value_USD;

any help greatly appreciated.

thanks

Bhavesh

Re: How to write filter condition in Bar and Line graph?

bhaveshp90 — Thu, 23 Aug 2018 19:14:10 GMT

I have used this condition but it failed,

if(Report_Param = 'Sales' and Header_2 = 'UDT' and Header_1 = 'Budget', sum(Value), 0)

Re: How to write filter condition in Bar and Line graph?

MarioCenteno — Thu, 23 Aug 2018 19:20:29 GMT

Try

=Sum({<Report_Param ={'Sales'}, Header_2= { 'UDT'}, Header_1= { 'Budget'}>}Value)

Re: How to write filter condition in Bar and Line graph?

bhaveshp90 — Thu, 23 Aug 2018 19:23:46 GMT

I tried your expression, but my line axis disappeared as shown below.

Re: How to write filter condition in Bar and Line graph?

MarioCenteno — Thu, 23 Aug 2018 19:29:53 GMT

Try

if(SUM({<[Report_Param] ={'Sales' }>}[Value]

SUM({<[Header_2] ={'UDT' }>}[Value]),

SUM({<[Header_1] ={'Budget' }>}[Value]

Re: How to write filter condition in Bar and Line graph?

bhaveshp90 — Thu, 23 Aug 2018 19:43:02 GMT

Perfect, this worked for me thank you.

Also, can you tell me how to count the project_no?

I am using count(project_no) in the bar expression which is showing incorrect no.

thanks

Re: How to write filter condition in Bar and Line graph?

MarioCenteno — Thu, 23 Aug 2018 19:46:09 GMT

Would you use the same conditions to count the bars?

Re: How to write filter condition in Bar and Line graph?

bhaveshp90 — Thu, 23 Aug 2018 19:49:32 GMT

I have two expressions,

Count (Project_No),

Value(USD) = (if(SUM({<[Report_Param] ={'Sales' }>}[Value]

SUM({<[Header_2] ={'UDT' }>}[Value]),

SUM({<[Header_1] ={'Budget' }>}[Value])

I have used the expression given by you for my Value, now the count of project_no is not accurate.

Should I use other condition for my count ?

Re: How to write filter condition in Bar and Line graph?

MarioCenteno — Thu, 23 Aug 2018 19:58:50 GMT

I suggest you create another post with your new challenge and I will gladly try to help you

I would also like you to explain a bit more about the lodge of your expression, I think I am not understanding correctly.