Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnakv831
Contributor
Contributor

date range

Hi How to show the attached date range in Qliksense. please guide

Labels (2)
2 Solutions

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Natively this use case scenario seems to be not supported. Natively you have only the following Date picker:

 

Your options for this use case scenario are: 

  1. Submit a feature request [1]
  2. Check if any other developer has created any customer extension that is closer to your needs [2]
  3. Try to create your own customer extension [3] to achieve the desired use case scenario 

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

---

[1] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...

[2] https://developer.qlik.com/garden

[3] https://help.qlik.com/en-US/sense-developer/November2020/Subsystems/Extensions/Content/Sense_Extensi...

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

justISO
Specialist
Specialist

You take 'Filter pane' object from Charts selection and put in your sheet somewhere you need. Try to keep it 'horizontal', as I suggested, 1 grid tall (if needed you can change height of your grid a bit in sheet properties -> grid spacing)

justISO_0-1652876347843.png

Now you add you dimension you want to filter (in my case I convert date to month by month([DATE FIELD])):

justISO_3-1652877033840.png

and set Title similarly to:

=concat(distinct month([DATE FIELD]), ' | ', month([DATE FIELD]))

Final result will look like this:

justISO_2-1652876947894.png * month names are in Lithuanian. For you they will be in your local language.

View solution in original post

4 Replies
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Natively this use case scenario seems to be not supported. Natively you have only the following Date picker:

 

Your options for this use case scenario are: 

  1. Submit a feature request [1]
  2. Check if any other developer has created any customer extension that is closer to your needs [2]
  3. Try to create your own customer extension [3] to achieve the desired use case scenario 

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

---

[1] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...

[2] https://developer.qlik.com/garden

[3] https://help.qlik.com/en-US/sense-developer/November2020/Subsystems/Extensions/Content/Sense_Extensi...

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
justISO
Specialist
Specialist

A partial workaround is to set the filter to one grid high with a field month([YOUR DATE FIELD]) and set Title to:

=concat(distinct month([YOUR DATE FIELD]), ' | ', [YOUR DATE FIELD])

so it will look like yours button row.

Or try to search horizontal selection extension if you really need button-like selection, not filter popup.

krishnakv831
Contributor
Contributor
Author

Can you please clearly explain what kind of filter I need to set on grid. I have the month filed so did title set as per your comments.

justISO
Specialist
Specialist

You take 'Filter pane' object from Charts selection and put in your sheet somewhere you need. Try to keep it 'horizontal', as I suggested, 1 grid tall (if needed you can change height of your grid a bit in sheet properties -> grid spacing)

justISO_0-1652876347843.png

Now you add you dimension you want to filter (in my case I convert date to month by month([DATE FIELD])):

justISO_3-1652877033840.png

and set Title similarly to:

=concat(distinct month([DATE FIELD]), ' | ', month([DATE FIELD]))

Final result will look like this:

justISO_2-1652876947894.png * month names are in Lithuanian. For you they will be in your local language.