topic Re: Detach in charts in QlikView

Detach in charts

Tue, 12 Nov 2013 10:30:18 GMT

Hi all

I am trying to detach a bar chart by using the expression below but it doesnt seem to work.

Num(If([Numerator Flag] = 1 And [Summarise Flag] = 0 , Avg({1}Numerator),

If([Numerator Flag] = 1 And [Summarise Flag] = 1, Sum({1}Numerator),

If([Numerator Flag] = 0 And [Summarise Flag] = 0, (Avg({1}Numerator)/Avg({1}Denominator)),

If([Numerator Flag] = 0 And [Summarise Flag] = 1, (Sum({1}Numerator)/Sum({1}Denominator)))))),[Format Code])

kaushiknsolanki — Tue, 12 Nov 2013 10:32:34 GMT

Hi,

What exactly is happening when you do some selection?

Regards,

Kaushik Solanki

Tue, 12 Nov 2013 10:38:51 GMT

Upon selections the bar chart changes. I would like it to be static independent of selections.

I wasnt sure if the expression is right.

Tue, 12 Nov 2013 15:31:18 GMT

Incorrect Syantax. 'No Data to display'