topic Re: How to add records of same group in QlikView

How to add records of same group

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

I want to add only the same kind of records.For example want to add records for ALL RMKs 700 together or all DMA together.

How can I add such an expression in the chart expression but not in the script...

Re: How to add records of same group

ogautier62 — Tue, 17 Jul 2018 11:19:27 GMT

Hi,

why don't you use NI Fuel Type as a dimension ?

regards

Re: How to add records of same group

sunny_talwar — Tue, 17 Jul 2018 11:23:42 GMT

Is Differential Re.... used a dimension? May be remove that as a dimension and that will remove the distinct value of Differential Re... and sum the same NI Fuel Type

Re: How to add records of same group

trishita — Tue, 17 Jul 2018 11:29:27 GMT

I have used it as a dimension.But I am not sure how to write a script or eXpression for it like..I would like to use something like:

if (Fuel_Type)='RMK' THEN sum(Computed ROB) and so on..i want individual addition of the fuel types

Re: How to add records of same group

trishita — Tue, 17 Jul 2018 11:30:12 GMT

i dont know how to sum same type of fuel values in side an chart expression

Re: How to add records of same group

sunny_talwar — Tue, 17 Jul 2018 11:36:41 GMT

Sorry, what?

Re: How to add records of same group

trishita — Tue, 17 Jul 2018 11:45:00 GMT

You wrote to sum the same NI Fuel type..Idont know how to do it in chart expression as i am not able to use the WHERE clause in an chart expression

like how would i write an expression for

select

sum(computedROB),

sum(ActualROB)

where NIFuelType='DMK'

GROUPBY Nifueltype

Re: How to add records of same group

sunny_talwar — Tue, 17 Jul 2018 11:47:49 GMT

You already have the chart created, don't you? All I am asking it to remove the Differntial Re... field from the list of dimensions... does that make sense?

Re: How to add records of same group

trishita — Tue, 17 Jul 2018 12:09:49 GMT

The problem persists

Re: How to add records of same group

pradosh_thakur — Tue, 17 Jul 2018 12:15:47 GMT

Do you have any hidden columns? And i hope Computed ROB, Actual Rob etc are in expression and not in dimension ?

If possible can you post a screen shot of the dimensions and expressions.

Re: How to add records of same group

sunny_talwar — Tue, 17 Jul 2018 12:17:01 GMT

Would you be able to share a sample?

Re: How to add records of same group

trishita — Tue, 17 Jul 2018 12:32:18 GMT

They are calculated dimensions....

The claculation is as follows:

Computed ROB. num(FUEL_MASS_BEFORE_SOUNDING/ 1000, ' ####.###', '.', ',' )

Re: How to add records of same group

pradosh_thakur — Tue, 17 Jul 2018 12:50:26 GMT

I think you need to add "Ni Fuel Type" dimension and others as expression. Not really sure what you are trying to achieve here. Please post sample.

Re: How to add records of same group

trishita — Tue, 17 Jul 2018 12:57:38 GMT

HERE IS THE SAMPLE..