topic Re: INLINE VARIABLE FORMULA in QlikView

INLINE VARIABLE FORMULA

Tue, 23 Apr 2013 21:52:43 GMT

How to create a variable with calculated formula like

LOAD * INLINE[

SET VAR1=DATE(2)-DATE(1), SET VAR2=DATE(3)-DATE(2),SET VAR3=DATE(4)-DATE(3)

AS $(FIELD1)

];

Can we use the field1 as one dimension in x-axis of the bar chart where y-axis will be average no of days?

Thanks

Wed, 24 Apr 2013 07:20:38 GMT

on your dashboard.

press CTRL+ALT+V

then clik on Add, write var1, then select var1, go to definition write =DATE(2)-DATE(1).

similarlly make another variable.

then on bar chart --

dimension--> field1

Expression--> $(var1)

nilesh_gangurde — Wed, 24 Apr 2013 07:54:22 GMT

Please find attachment.

-Nilesh