topic Re: Help in replacing the expression in QlikView

Help in replacing the expression

bharatkishore — Thu, 24 Jan 2019 13:13:42 GMT

Hi All,

@sunny_talwar

i have the below expression

Sum(TOTAL <[Product Group], [Part Type], Contract_Type_Group,District,[System Code]> Consumption)

In the above expression i need to add where it is sum of Consumption should be replaced by

(sum(Consumption)*12 / Count(Distinct Year & Month))

Can you please help how to do it.

Thanks,

Bharat

Re: Help in replacing the expression

sunny_talwar — Thu, 24 Jan 2019 13:16:25 GMT

Don't really understand it. Sample? 🙂

Re: Help in replacing the expression

bharatkishore — Thu, 24 Jan 2019 13:24:00 GMT

Sunny Bhai i have an sample expression as
Sum(Consumption) and this expression should be replaced by
(sum(Consumption)*12 / Count(Distinct Year & Month)) which is done.
Now i have the above expression i.e.
Sum(TOTAL <[Product Group], [Part Type], Contract_Type_Group,District,[System Code]> Consumption)
Now i have sum( total( consumption) with some fields and in this expression i need to add
sum(total(fields) and instead of consumption i need to add this one (sum(Consumption)*12 /
Count(Distinct Year & Month))
Hope i am clear.
Please let me know Sunny Bhai if you need anything..

Re: Help in replacing the expression

sunny_talwar — Thu, 24 Jan 2019 13:34:21 GMT

I won't be able to offer much help without a sample file where you can show me what you are getting and what you intend to get

Re: Help in replacing the expression

MindaugasBacius — Thu, 24 Jan 2019 14:56:02 GMT

Are you looking for this?
Sum(TOTAL <[Product Group], [Part Type], Contract_Type_Group,District,[System Code]> Consumption) * 12 / Count(Distinct <[Product Group], [Part Type], Contract_Type_Group,District,[System Code]> Year & Month)