topic Straight table conditional value doesn't work in QlikView

Straight table conditional value doesn't work

Sun, 01 May 2016 16:11:32 GMT

Hi,

I am trying to achieve the following:

I want to show records were two fields in the same record differs.

For this I am using a condtional validation construction like this:

=num(inc_Aantal_bon)<>num(inc_Antal_art)

so the fields compared are inc_Aantal_bon with inc_Antal_art when these differ I want to show them.

I put them on the dimension and on the expression as conditional value like this:

The result of this:

So I got rows were both are equal. I played with it for hours but can't figure out why.

I hope you can help me.

John

Re: Straight table conditional value doesn't work

sunny_talwar — Sun, 01 May 2016 16:45:29 GMT

I think you don't need a conditional statement. You need a calculated dimension here. Replace your dimension inc_BonNr with this:

If(Num(inc_Aantal_bon) <> Num(inc_Antal_art), inc_BonNr)

and make sure to select 'Suppress When Value Is Null' to suppress Null Value in dimensions

Re: Straight table conditional value doesn't work

Gysbert_Wassenaar — Sun, 01 May 2016 16:50:02 GMT

The Conditional option is to show or hide the expression column altogether. It operates at the chart level, not the row level.

This expression: =num(inc_Aantal_bon)<>num(inc_Antal_art) is a boolean test. It returns either true or false. And since it's not aggregated over a dimension it doesn't return anything.

Try using inc_BonNr as dimension and as expressions

Aantal bon: =if(inc_Aantal_bon <> inc_Antal_art, inc_Aantal_bon)
Aantal art: =if(inc_Aantal_bon <> inc_Antal_art, inc_Aantal_art)

Actually, a bit nicer is to not use the If statement at all, but another way to filter the relevant inc_BonNr values:

Aantal bon: only({<inc_BonNr={'=inc_Aantal_bon<>inc_Antal_art'}>}inc_Aantal_bon)
Aantal art: only({<inc_BonNr={'=inc_Aantal_bon<>inc_Antal_art'}>}inc_Aantal_art)

These kinds of statements are called set analysis expressions. The part {<inc_BonNr={'=inc_Aantal_bon<>inc_Antal_art'}>} selects only those inc_BonNr values where inc_Aantal_bon is not equal to inc_Antal_art.