Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
To filter the data between these two parameter like input criterea or can say two date selection period, in QlikView need help with a basic example.
Requirement: From Date : DD/MMM/YYYY
: To Date : DD/MMM/YYYY
Then the data should be within those period.
Best Regards,
Shubham
see file attached.
Regards
Rahul
Thanks Rahul,
I need one more help. I have too many fields in my database related to dates, and all are required for some particular calculation. Please tell me how to make link between those date fields to the master table.
best regards,
Skumar
I have linked the master table and the inline table. Hope it helps!
Hi,
I think you have copied the same qvw and there is no change. Please let me know if you have done any changes, and one more thing I want to link more than one date fields in the master calender.
Thanks,
Skumar
I have refreshed the qvw and sent back. Thought it was connected before.
Rename the other fields as 'Date' which will help you to connect to the master calendar.
I tried but it's not working...it doesn't change while changing the two date parameter created with the help of above example.
Hi,
In each of the table create an additional date field and in the example i posted change the varMinDate and varMaxDate variables to following:
LET varMinDate = Num(rangemin(Peek('DateName1', 0,'TableName1'), Peek('DateName2', 0,'TabbleName2'), Peek('DateName3', 0,'TableName3')));
LET varMaxDate = Num(rangemax(Peek('DateName1', -1,'TableName1'), Peek('DateName2', -1,'TabbleName2'),Peek('DateName3', -1,'TableName3')));
Where DateNameX and TableNameX have to be replaced with field names from your data model.
By doing the above two steps you will:
1. Have a key field date, which you can use on the front end as a selection and would work with all your table
2. By mantaining the original date field you can use those indipendently as you use now
3. By changing the Max and Min variable you wil be able to auto genrate dates between the dates that exist in your table
Hope this help.
Regards
Rahul
Hi Rahul,
Thanks for your reply. The date name and table name which you are referring should be original name as coming from database or what we have renamed in our qlikview script. and once that done do I need to use varMaxDate & varMinDate as from and to date calender object?
Need advise, since it's not changing as intended.
Best Regards,
Skumar
Hope it helps!