Date filter - From & To date along with alternate state

[ziaulhaque]

Hi all,

Recently I am facing an issue with qlikview chart. 

Problem:

My Dataset cols are date, name and value

1. Filtered the data between from & to date of date column

2. choose one option from name column (name1 from name1, name2, name3) - multiple list box

3. Prepare line chart  sum of values

Current stage:

1. create two preciding tables using date column of master table 

2. create alternate states for all multiple list box 

Chart expression:

=only({$<date={"<=$(=only(todate))>=$(=only(fromdate))"}}{Param1} value)

Error: 

No data to display

Please help.

[ziaulhaque · Accepted solution]

Hi Guys, It is resolved thankfully. I thought it would help you to new bee of qlikview like me. Proper syntax
=Only({Param1<date={"<=$(=only(todate))>=$(=only(fromdate))"}>}value)

[risht2]

Hi, can you please share a workbook. I am trying to do something similar, but struggling to add parameters only.. hence all the other steps have not been initiated only. It will be very helpful if you could share a sample worksheet.