Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Date filter - From & To date along with alternate state

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.

 

Tags (1)
1 Solution

Accepted Solutions
Highlighted
New Contributor II

Re: Date filter - From & To date along with alternate state

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)

View solution in original post

2 Replies
Highlighted
New Contributor II

Re: Date filter - From & To date along with alternate state

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)

View solution in original post

Highlighted
New Contributor

Re: Date filter - From & To date along with alternate state

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.