topic Re: Create a dimension based on if statement in QlikView

Create a dimension based on if statement

qvhjenvo — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to create a dimension in a fact table

What I want is to make the new dimension (CustNo_noSales) that shows customer who have [PY Sales] = 0

LOAD [Customer Number],

[CY Sales],

[PY Sales]

aggr(if(sum({<[PY Sales]={0}>}[PY Sales]), CustNo_noSales),CustNo_noSales)

FROM

(ooxml, embedded labels, table is Ark1);

aggr(if(sum({<[PY Sales]={0}>}[PY Sales]), CustNo_noSales),CustNo_noSales)

This statement does not work.

I need help!

Regards

Loi

sunny_talwar — Tue, 08 Mar 2016 18:44:53 GMT

Try this:

LOAD [Customer Number],

[CY Sales],

[PY Sales],

If([PY Sales] = 0, [Customer Number]) as CustNo_noSales

FROM

(ooxml, embedded labels, table is Ark1);

maxgro — Tue, 08 Mar 2016 19:14:47 GMT

Also in the chart with a calculated dimension

=if(([PY Sales])=0, [Customer Number])

qvhjenvo — Wed, 09 Mar 2016 07:39:13 GMT

Thanks, Sunny.

It works.

jagan — Wed, 09 Mar 2016 07:49:00 GMT

Try like this

LOAD [Customer Number],

[CY Sales],

[PY Sales]

if(sum([PY Sales]) = 0, [Customer Number]) AS CustNo_noSales)

FROM

(ooxml, embedded labels, table is Ark1)

Group By [Customer Number];

Hope this helps you.

Regards,

jagan.