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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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
“Aspire to Inspire before we Expire!”