topic Re: Expression Help.......................??? in QlikView

Expression Help.......................???

aveeeeeee7en — Mon, 26 May 2014 10:34:51 GMT

Hi Community

I am facing issue in Expression.

I have calculated [Gross Sales] from Script using GROUP BY Key

Now, I want to calculate Percentage*[Gross Sales]

The Result i am getting is not desired output.

Kindly see the Attachment.

Regards

Aviral

Re: Expression Help.......................???

jagan — Mon, 26 May 2014 10:42:40 GMT

Hi,

Try this expressions

=Only(Percentages)*Column(1)

and

Avg(Percentages)*Column(1)

or Max(Percentages)*Column(1)

or Min(Percentages)*Column(1)

Regards,

jagan.

Re: Expression Help.......................???

Anonymous — Mon, 26 May 2014 10:42:42 GMT

Hi Nag,

The numberw which are displayed in the Percentage*[Gross Sales] is correct.

If you calculate 298252*0.07= 20877.64 which is displayed correctly

Let me know what value you are lokking for.

Re: Expression Help.......................???

tresB — Mon, 26 May 2014 10:43:29 GMT

Re-write formula like:

=Sum(Percentages * [Gross sales])

Re: Expression Help.......................???

Anonymous — Mon, 26 May 2014 10:45:52 GMT

sorry.Kindly ignore my previous message

Go to expression tab->Total Mode->Instead of Total Mode change that to Sum(below)

Re: Expression Help.......................???

aveeeeeee7en — Mon, 26 May 2014 10:46:59 GMT

Thanks Sir

But the Expressions are not working.

Re: Expression Help.......................???

aveeeeeee7en — Mon, 26 May 2014 10:48:42 GMT

Thanks Dass

But I don't want todo it that way.

I want tounderstand why it is not showing Expression Total.

Re: Expression Help.......................???

ashfaq_haseeb — Mon, 26 May 2014 10:49:00 GMT

Hi may be like this.

Regards

AHFAQ

Re: Expression Help.......................???

aveeeeeee7en — Mon, 26 May 2014 10:54:28 GMT

Thanks Ashfaq

But Acccording to your logic, i am getting different Results both in Table No.1 & Table No.2.

I want the Same Result i.e, 4779104.3938424 in Both Tables.

Re: Expression Help.......................???

aveeeeeee7en — Mon, 26 May 2014 11:04:36 GMT

Thank You Jagan

I have used Only(Percentages)*Sum(GrossSales) from the Backend using Group By.

It worked like a charm.

Thanks Again.

Regards

Aviral Nag

Re: Re: Expression Help.......................???

ashfaq_haseeb — Mon, 26 May 2014 11:05:58 GMT

Hi,

Find the updated Application.

Regards

ASHFAQ

Re: Expression Help.......................???

aveeeeeee7en — Mon, 26 May 2014 11:18:52 GMT

Thank You All for your Amazing replies.

I Appreciate all of your Efforts.

Regards

Aviral Nag