Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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.

 

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

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
Contributor II
Contributor II

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
Contributor
Contributor

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.