topic Re: Filter Sum Based on Project Name in QlikView

Filter Sum Based on Project Name

Mon, 27 Jul 2015 09:57:45 GMT

Hi All,

Please find the attached Qvw. I have mentioned all the details in the Qvw.

I need to filter data based on P_name(Project name).

Current Value for Sum is below.

Num(

Sum({<FlagType={8},FiscalYearNo={"$(=max(FiscalYearNo))"},Level0={'Outflow'}>}Cashflow_Amount)

if(Sum({<FlagType={8},FiscalYearNo={"$(=max(FiscalYearNo))"}>}Cashflow_Amount)<0 and Level0='Inflow','#,##0;(#,##0)',

if(Dimensionality()=0 and Cashflow_Amount<0,'#,##0;(#,##0)','#,##0;#,##0'))

)

Here i need to add one more field P_name to filter Sum. SO that it displays only for P_name.

P_name is project name and it has 11 Projects.

Let me know if you need more details.

Thanks in advance.

Regards,

Keerthi KS

sunny_talwar — Mon, 27 Jul 2015 10:17:23 GMT

You want to see your table to display like this?

I just selected 'Suppress When Value Is Null' on the Dimension tab of the chart properties:

I hope that this is what you were looking for?

Best,

Sunny

Mon, 27 Jul 2015 10:19:37 GMT

Thanks a lot Sunny.

sunny_talwar — Mon, 27 Jul 2015 10:20:31 GMT

No problem

I am glad I was able to help.

Best,

Sunny