topic Set Analysis Behaviour in QlikView

Set Analysis Behaviour

shannoypaul — Fri, 09 Dec 2016 09:42:01 GMT

TenderAddedFlag 0,1

TenderRemovedFlag 0,1

I am creating a Bridge Chart.

Expressions:

Current Tender Value - Sum(DISTINCT [Current Tender Value (USD)])

Tender Removed - Sum({<TenderRemovedFlag ={1}>}DISTINCT [Volume Change Value (USD)])

Volume Change - Sum({<TenderRemovedFlag ={0},TenderAddedFlag ={0}>} DISTINCT [Volume Change Value (USD)])

Tender Added - Sum({<TenderAddedFlag ={1}>} DISTINCT [Volume Change Value (USD)])

New Tender Value - Sum(DISTINCT Next Tender Value (USD)])

Issue - Tender Added expression is never displayed

Re: Set Analysis Behaviour

Fri, 09 Dec 2016 10:01:24 GMT

Do you have values populated in TenderAddedFlag with 1

Re: Set Analysis Behaviour

sunny_talwar — Fri, 09 Dec 2016 10:09:32 GMT

Have you converted your chart into a straight table to see if there is any value for the expression or is it just not showing anything on the chart. Would it be possible to share a sample to see the issue?

Re: Set Analysis Behaviour

shannoypaul — Fri, 09 Dec 2016 10:55:03 GMT

Attached Sample Data.

Kindly Ignore the bridge, If I need to display all bars at a time using the expressions.

Re: Set Analysis Behaviour

tresB — Fri, 09 Dec 2016 11:05:47 GMT

If I filter your excel sheet to _TenderAddedFlag -> 1, I get blank Volume Change Value (USD) column. So sum(Volume Change Value (USD)) with that filter would generate zero.

Re: Set Analysis Behaviour

shannoypaul — Fri, 09 Dec 2016 11:06:03 GMT

Got it, For Tender Added Flag, Volume Change is always null hence the calculation out puts zero