topic Re: Conditional Header in QlikView

Conditional Header

Anonymous — Tue, 09 Feb 2016 13:13:15 GMT

Dear all

I need conditional header based on first header for below both cases.

If F2 = 'P' than F3 or VALUELIST should be 'X' only(Y & Z want to hide in case of F2 =P)

Case 1: Actual data(F3) used as dimension

Case 2: Valuelist used instead of F3

Sample QV attached. I appreciate your help and efforts

Thanks

Re: Conditional Header

sunny_talwar — Tue, 09 Feb 2016 13:20:39 GMT

You want it for both the charts?

Actual Dim from Data chart's expression:

If((F2 = 'P' and F3 = 'X') or F2 <> 'P', Sum(V1))

Re: Conditional Header

Anonymous — Tue, 09 Feb 2016 13:27:27 GMT

Hi Sunny

Thanks for quick help, I will try after sometime.

I need solution in both cases please.

Thanks again

Re: Conditional Header

Peter_Cammaert — Tue, 09 Feb 2016 13:34:03 GMT

=If ((F2 <> 'P') or (F3 = 'X'), Sum(V1))

Re: Conditional Header

sunny_talwar — Tue, 09 Feb 2016 13:35:38 GMT

May be this with the ValueList:

If(F2 <> 'P' or not Match(ValueList('X', 'Y', 'Z'), 'Z', 'Y'),

If(ValueList('X', 'Y', 'Z') = 'X', 11,

If(ValueList('X', 'Y', 'Z') = 'Y', 22,

If(ValueList('X', 'Y', 'Z') = 'Z', 33))))

Re: Conditional Header

Peter_Cammaert — Tue, 09 Feb 2016 13:40:11 GMT

Why doesn't Sunny's table get filled like in your example? Because as soon as you introduce an existing field in the expression, normal associative logic kicks in and only existing combinations of dimension values will produce an expression result.

Re: Conditional Header

sunny_talwar — Tue, 09 Feb 2016 13:43:00 GMT

Hahahaha and I was too shy to admit that the results don't match because I did not know why they were not. Thanks Peter

Re: Conditional Header

alexpanjhc — Tue, 09 Feb 2016 14:32:58 GMT

maybe like this?

Re: Conditional Header

Anonymous — Tue, 09 Feb 2016 19:47:53 GMT

Hi Sunny

It works .

Thanks for suggestion.