topic Re: Expression in QlikView

Expression

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

if(DRGRSLT='Soap' ,count(distinct ID)*.35,'')

In Above expression I am considering only "Soap" from the field Lead,

How do i write a expression where upon i can select anything from the field ?

For exmaple :

if(Lead='*' ,count(distinct ID)*.35,'') Which is not working ?

and also i want to condier two fields

if(Lead='Soap', andif(product='*' ,count(distinct ID)*.35,'')

Can someone please throguth some light on this

Kushal_Chawda — Fri, 18 Mar 2016 09:57:31 GMT

like this?

count(distinct {<Lead={'*'}>} ID)*0.35

count(distinct {<Lead={'Soap'},Product={'*'}>} ID)*0.35

sunny_talwar — Fri, 18 Mar 2016 09:58:09 GMT

I have no idea what you are trying to do here, is there a sample you can share with the expected output?

Chanty4u — Fri, 18 Mar 2016 09:59:58 GMT

is this may be

count(distinct{<lead={'*'}>}id)*0.35

Anonymous — Fri, 18 Mar 2016 10:11:03 GMT

Is their any difference b/w your expression and this?

'*' means every thing, is this really required to pass in SET?

=count(Distinct ID)*0.35

=count({<Lead={'Soap'}>} ID)*0.35

sunny_talwar — Fri, 18 Mar 2016 10:13:32 GMT

When you add this -> {'*'} in ignore null

Sum({<Country = {'*'}>} Sales) can be different from Sum(Sales) if there are places where Country is null.

sasiparupudi1 — Fri, 18 Mar 2016 10:28:13 GMT

Try the following

count(distinct {1<lead={'*'}>}ID)*.35

Anonymous — Fri, 18 Mar 2016 10:40:23 GMT

Putting '*' means it will ignore null, Is it?

sunny_talwar — Fri, 18 Mar 2016 10:43:34 GMT

Yes

Anonymous — Fri, 18 Mar 2016 10:47:29 GMT

Okay, have not obsereved it earlier

Thanks for clarification