topic Re: Expression Problem in QlikView

Expression Problem

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

My need is to return only the field with type number (eliminate the fields that contain string or character)

I wrote this expression.

Avg({<isNum($(Bruttoeinkommen))={-1}>}Bruttoeinkommen) the editor sgow me Expression ofk but there isn#t any returned data

Re: Expression Problem

sunny_talwar — Tue, 19 Apr 2016 16:09:55 GMT

Try this:

Avg(If(IsNum(Bruttoeinkommen), Bruttoeinkommen))

Avg({<Bruttoeinkommen = {"=IsNum(Bruttoeinkommen)"}>}, Bruttoeinkommen)

Re: Expression Problem

Colin-Albert — Tue, 19 Apr 2016 16:26:04 GMT

AVG is a numeric expression so will exclude any non-numeric data.

AVG(Bruttoeinkommen) should work.

Re: Expression Problem

Chanty4u — Tue, 19 Apr 2016 16:28:15 GMT

may wrks with

Avg(Field)

Count of rows with no nulls?

Re: Expression Problem

Anonymous — Tue, 19 Apr 2016 16:29:46 GMT

Maybe.

Avg(If(IsNum(Bruttoeinkommen)=-1, Bruttoeinkommen))

Avg(If(IBruttoeinkommen='-1', Bruttoeinkommen))

Regards

Re: Expression Problem

Tue, 19 Apr 2016 18:28:54 GMT

I try All but I still have the same problem :

For the salary average I get illogical result with Avg(): every day I get Information about the salary (I get null also as a value )with different criteria so when I try to find the AVG() it return a biiig biiig amount !!!!!!!

I thought it is problem of AVG but it seems to be another problem ???

some one could help me how should I think to get the AVG()

Re: Expression Problem

sunny_talwar — Tue, 19 Apr 2016 18:40:04 GMT

Can you share a sample showing the issue?

Re: Expression Problem

Tue, 19 Apr 2016 19:09:30 GMT

My data is Like This but it is very huge . I want to get the average salary : for each criteria:

Day	Salary	Experience	Sector
Apr 07 2016 12:35:49 GMT	47000	3	IT
Apr 07 2016 12:33:31 GMT	90.000	15	Business
Apr 07 2016 12:43:16 GMT	114000	20	Sales
Apr 07 2016 12:42:34 GMT	60000	15	IT
Apr 07 2016 12:43:12 GMT	98.000	10	Business
Apr 07 2016 12:41:55 GMT	45000	5	Sales
Apr 07 2016 12:46:31 GMT	null	6	IT
Apr 07 2016 12:45:52 GMT	75.000	7	Business
Apr 07 2016 12:46:31 GMT	37th	8	Sales
Apr 07 2016 12:48:03 GMT	80000	9	IT
Apr 08 2016 12:49:40 GMT	96000	10	IT
Apr 08 2016 12:49:40 GMT	95000	11	Sales
Apr 08 2016 12:49:40 GMT	165000	12	sales
Apr 08 2016 12:49:40 GMT	90000	13	other

Re: Expression Problem

sunny_talwar — Tue, 19 Apr 2016 19:15:58 GMT

What is the criteria here? Expected output?

Re: Expression Problem

sunny_talwar — Tue, 19 Apr 2016 19:20:21 GMT

Created a cycle group with Day, Experience and Sector as dimensions.

When we are on Experience, you would see this:

When on Sector

Re: Expression Problem

Tue, 19 Apr 2016 19:25:17 GMT

the average salary by sector , by experience .

Re: Expression Problem

sunny_talwar — Tue, 19 Apr 2016 19:34:26 GMT

Did you look at the attachment above?

Re: Expression Problem

Tue, 19 Apr 2016 19:46:21 GMT

yes it should be like this , what was your condition : in my case isn't as simpel as that I get average witt Milliard Eur !!! how did resolve the problem to get the data of one day !!!

Re: Expression Problem

Tue, 19 Apr 2016 19:51:52 GMT

What did you mean by "Created a cycle group with Day"

Re: Expression Problem

sunny_talwar — Tue, 19 Apr 2016 20:40:16 GMT

I just used Avg(Salary) and it seems to work. Have you tried using just Avg(Salary)

Re: Expression Problem

Tue, 19 Apr 2016 20:43:41 GMT

Yes I did and it gives me an average with Mio eur