topic Re: total grouping expression in QlikView

total grouping expression

kunkumnaveen — Wed, 02 Aug 2017 11:17:55 GMT

Hello,

i am getting different total spend value before selecting any material and after selecting ,the values i am getting after selection is correct values

before selecting any material all the total spend is wrong

after selecting material the total spend is correct

expression i wrote for total spend is

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[FISCAL YEAR]={$(=max([FISCAL YEAR])-1)}>}total<New_Column,[PLANT NAME]>SPEND)

New_Column labeled as Material

i think something is going wrong in my expression .How to make same values to appear even before selecting any material as i am grouping with material and plant name

thanks

Re: total grouping expression

Anil_Babu_Samineni — Wed, 02 Aug 2017 11:24:30 GMT

What are you selecting here? I wonder where you are doing this type of magic charts. Will you able to provide application to check?

Re: total grouping expression

kunkumnaveen — Wed, 02 Aug 2017 11:41:56 GMT

Hi I just took screen short and cut only to get tables

The second pic has selected material

Re: total grouping expression

Anil_Babu_Samineni — Wed, 02 Aug 2017 11:46:50 GMT

In fact, there is no any wrong in set operator. But, I would ask you to copy and paste same expression until you provide sample application

Re: total grouping expression

kunkumnaveen — Wed, 02 Aug 2017 11:52:20 GMT

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[FISCAL YEAR]={$(=max([FISCAL YEAR])-1)}>}total<New_Column,[PLANT NAME]>SPEND)

New_Column labeled as Material

Re: total grouping expression

kunkumnaveen — Wed, 02 Aug 2017 11:55:41 GMT

Only one thing I want to known the total spend which I am getting after selecting a material pic2 will it possible to get same values for that material even before selecting that particular material,is there any alternative way to write this expression

Re: total grouping expression

Anil_Babu_Samineni — Wed, 02 Aug 2017 11:56:14 GMT

Some how you used correct one only as i feel, Even Label names we can't take it as straight forward. And that do you get any error over expression. I am not?

Re: total grouping expression

Anil_Babu_Samineni — Wed, 02 Aug 2017 11:56:47 GMT

May be, Would you like to provide sample work file