Solved: Re: Need help in BAR GRAPH - Qlik Community

Report Inappropriate Content · ‎2013-04-06

Hi,

I need a bar graph, where, if My Actula Amount between

Sum ({<FY=>}if(Period >= date(MakeDate(2012,07,01)) and Period <=date(MakeDate(2013,03,31)),ACTUAL_MT_SOLD))

kaushiknsolanki · ‎2013-04-07

Try this.

Sum({<Period = {">=$(=makedate(2012,07,01))<=$(=makedate(2013,03,31))"},FY=>}Actual_Mt_Sold)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2013-04-07

Try this.

Sum({<Period = {">=$(=makedate(2012,07,01))<=$(=makedate(2013,03,31))"},FY=>}Actual_Mt_Sold)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2013-04-08

Hi Kaushik,

I tried by that expression, But not get resolved the same. Is it working u'rside properly, So would you like to share some example.

Thanks for solution and reply.

Ami.

kaushiknsolanki · ‎2013-04-09

Hi Ami,

Please share the sample qvw file.

Regards,

Kushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Need help in BAR GRAPH