Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ziaulhaque
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
ziaulhaque
Contributor II
Contributor II
Author

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

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