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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Displaying Data for Current Month when no selection is made

Hi All ,

Please assist me how to show the current year and current month data when opening the model or no selection is made as the report is going out of memory.

As I am new to qliksense please kindly assist by providing step by step details solution.

I have created the filter pane but the application is close the selection is resetting. All the data is loading when opening the Qliksense app.

Sample model attached. The model got only Year 2019 and Month Jul 2018 data. 

Showing like this.

likethis.PNG

Thanks in Advance.

1 Solution

Accepted Solutions
suvechha_b
Creator III
Creator III
Author

I have resolved the problem by using an extension that can do that ; Styled List: As , I got too many expression in my sheet.

https://github.com/countnazgul/Qlik-Sense-Styled-Lists-Extension

Example of use:

After installing follow the stepsCapture.PNG

 

 

Then Step 2: Add the styled list in the sheet.

Step2.PNG

View solution in original post

4 Replies
Channa
Specialist III
Specialist III


=Sum({$<[Ship Date]={">=$(MonthStart(max(date)))<$(=monthend(max(date))"}>}Sales)

 

it will bring selected month or max month date

Channa
suvechha_b
Creator III
Creator III
Author

Hi Channa ,

I want the selection pane to get the value. like below.

selection.PNG

Channa
Specialist III
Specialist III

=Sum({$<[Ship Date]={">=$(MonthStart(max(date)))<$(=monthend(max(date))"}>}CliensPaied)

 

do this for all measures in pivot

 

Channa
suvechha_b
Creator III
Creator III
Author

I have resolved the problem by using an extension that can do that ; Styled List: As , I got too many expression in my sheet.

https://github.com/countnazgul/Qlik-Sense-Styled-Lists-Extension

Example of use:

After installing follow the stepsCapture.PNG

 

 

Then Step 2: Add the styled list in the sheet.

Step2.PNG