Need help in Expression

Thu, 26 Apr 2012 05:33:42 GMT

Good Morning Friends,

As I would like to create a line chart with two dimentions (From Date), (To Date) the messure is (Value).

The objective is if I choose the from date and to date, the chart has to show the between values.

Thanks in advance.

Regards

Chriss

Thu, 26 Apr 2012 06:50:06 GMT

Hi,

You can do this using variables.

Make 2 variables, one say v_from_date and another say v_to_date .

In your charts expression use set analysis.

sum({< [From Date] = {"< = $(v_from_date)"} , [To Date] = {"< = $(v_to_date)"} >}value)

You can create 2 list boxes one for [From Date] and another for [To Date].

and set these variables as

v_from_date = min([From Date])

v_to_date = max([ToDate])

so, be defualt your chart will show all the data and as you make selections, it will change its values.

Hope it helps! Let me know if any issue. !

...

Ashutosh

topic Need help in Expression in QlikView