topic Re: Show values with codition is null in QlikView

Show values with codition is null

Mon, 10 Aug 2015 14:01:07 GMT

I want to display values with condition column 'Hors Vente' = - (Null)

Thx in advance

Re: Show values with codition is null

sunny_talwar — Mon, 10 Aug 2015 14:04:31 GMT

Is equal to null or is not Equal to null???

Is Equal to null:

{<[Hors Vente] = {"$(=Len(Trim([Hors Vente])) = 0)"}>}

Is not Equal to Null:

{<[Hors Vente] = {"$(=Len(Trim([Hors Vente])) > 0)"}>}

Re: Show values with codition is null

teiswamsler — Mon, 10 Aug 2015 14:05:52 GMT

Hi Stanley

Inn the script you can use isnull() statement to flag out tranactions with ( - )

/Teis

Re: Show values with codition is null

kuczynska — Mon, 10 Aug 2015 14:18:31 GMT

You can always assign your own value to NULLs in your load script:

NullAsValue *; //you can always predefine the set of fields you want to populate with nulls, in my case it's all fields, you can only mention [Horse vente] field of course.
Set NullValue = 'MyOwnNULLValue'; //this can be defaulted to numerical/alphanumerical value, depends on what you want to achieve

After this it should be easier for you to filter for values, exclude/include your nulls or simply use some Set analysis to ignore null values from your sum/count.

Re: Show values with codition is null

Mon, 10 Aug 2015 14:26:14 GMT

In scripting you can write like below

if(isNull([Hors Vente]),'Give Ur Value',[Hors Vente]) as [Hors Vente]

the above script will fill your null values with your own data

Re: Show values with codition is null

Mon, 10 Aug 2015 16:44:59 GMT

I just want something like this in calculated dimension:

Re: Show values with codition is null

Mon, 10 Aug 2015 17:03:11 GMT

Hi Teis. Thx for the answer... I'm just looking for something like this in calculated dimension:

Thx in advance

Re: Show values with codition is null

Kushal_Chawda — Mon, 10 Aug 2015 17:08:35 GMT

create calculated dimension as

if( Isnull([Hors Vente]) or len(trim([Hors Vente]))<=0, 'Null',[Hors Vente])

Re: Show values with codition is null

Mon, 10 Aug 2015 17:15:17 GMT

It's not goog. Th result:

I want to show values with condition 'Hors vente' = Null or -

Re: Show values with codition is null

Kushal_Chawda — Mon, 10 Aug 2015 17:23:47 GMT

You want to show some values where Hors Vente is null , is that what you are looking for?

Re: Show values with codition is null

Mon, 10 Aug 2015 17:26:00 GMT

exactly...

thx in advance

Re: Show values with codition is null

Kushal_Chawda — Mon, 10 Aug 2015 17:37:30 GMT

Create Calculated dimension.

if( Isnull([Hors Vente]) or len(trim([Hors Vente]))<=0, SellEndDateProduct,null())

Check Suppress when value is null for this calculated dimension

Re: Show values with codition is null

Mon, 10 Aug 2015 17:44:40 GMT

Does not work. I want to show only values (NameProduct) with condition column 'Hors vente' = Null or -

Re: Show values with codition is null

Kushal_Chawda — Mon, 10 Aug 2015 17:47:42 GMT

Can you post screenshot of your expression you have written? or it will be better if you can share sample application

Re: Show values with codition is null

sunny_talwar — Tue, 11 Aug 2015 01:43:29 GMT

May be this:

=If(Len(Trim([Hors Vente])) = 0, NameProduct) and Check 'Suppress When Value is Null' on the Dimension tab.

The above calculated dimension expression should replace NameProduct dimension.

I hope this is what you are looking to get.

Best,

Sunny

Re: Show values with codition is null

Tue, 11 Aug 2015 11:26:40 GMT

Thx, but does not work

Stanley