topic Re: expression in QlikView

expression

nareshthavidishetty — Tue, 05 Jan 2016 06:07:14 GMT

Hi all,

i developed gantt chart using bar graph dimension is LIstName,and expreesion is max(Date(WOOrderEnd))-min(Date(WOOrderStart)) and in the offset expression is (WOOrderStart) and i written expressions in the axis tab staticmin,static max

if(GetSelectedCount(WOMonth)=1,Min(WOOrderStart),Min{1}(WOOrderStart))

if(GetSelectedCount(WOMonth)=1,max(WOOrderStart),Max{1}(WOOrderStart))

im struck with the expression actually im trying to show days on the x axis like if you click month field january then in the chart on x axis it should display 1,2,3...31 what is the expression please help me out bit urgent

Re: expression

tamilarasu — Tue, 05 Jan 2016 06:17:39 GMT

Hi,

Check your expression,

if(GetSelectedCount(WOMonth)=1,Min(WOOrderStart),Min({1}(WOOrderStart)) )

if(GetSelectedCount(WOMonth)=1,max(WOOrderStart),Max({1}(WOOrderStart)) )

Re: expression

Anonymous — Tue, 05 Jan 2016 06:22:28 GMT

try with this:

if(GetSelectedCount(WOMonth)=1, Min(WOOrderStart), Min({1}WOOrderStart))

if(GetSelectedCount(WOMonth)=1, max(WOOrderStart), Max({1}WOOrderStart))

Re: expression

nareshthavidishetty — Tue, 05 Jan 2016 06:56:40 GMT

thanks for the reply but still im not getting the desired output i changed the expression mentioned by you

any help plz where im going wrong

if(GetSelectedCount(WOMonth)=1,Min(WOOrderStart),Min({1}(WOOrderStart)) )

if(GetSelectedCount(WOMonth)=1,max(WOOrderStart),Max({1}(WOOrderStart)) )

Re: expression

nareshthavidishetty — Tue, 05 Jan 2016 06:57:45 GMT

actually im trying to display days like1,2,3,4....31 if i clik jan filter on the x axis please help me

Re: expression

tamilarasu — Tue, 05 Jan 2016 07:10:37 GMT

Could you post your application.!

Re: expression

PradeepReddy — Tue, 05 Jan 2016 07:24:50 GMT

might be helpful...

Recipe for a Gantt chart

Files for creation of a Gantt chart

Re: expression

HirisH_V7 — Tue, 05 Jan 2016 07:38:58 GMT

Hi,

Post your app

-Hirish