Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

expression

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

7 Replies
tamilarasu
Champion
Champion

Hi,

Check your expression,

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

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

Anonymous
Not applicable

try with this:

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

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

nareshthavidishetty
Creator III
Creator III
Author

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)) )

nareshthavidishetty
Creator III
Creator III
Author

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

tamilarasu
Champion
Champion

Could you post your application.!

PradeepReddy
Specialist II
Specialist II

HirisH_V7
Master
Master

Hi,

Post your app

-Hirish

HirisH