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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-03-04 08:16 PM

Custom Report

Hi,

I have a requirement for Custom Report functionality in QV. I have created a custom report, but I want to limit my year variable to show only latest 2 years of data, however other sections of the dashboard needs all years. Can I restrict that in Custom Report.

Attached is tyhe sample QVW

Any help would be appreciated.

Simky

Labels (1)
Labels
dynamic pivot.qvw
837 Views
2 Replies
chiru_thota
Specialist
Specialist
‎2014-03-04 08:47 PM

you can do that

Variable1=max({1}Year)&chr(39)&','&chr(39)&max({1}Year-1)

Sum({<Year={'$(Variable1)'}>}Sales)

Custome report.jpg

dynamic pivot.qvw
652 Views
0 Likes
vikasmahajan
MVP
MVP
‎2014-03-04 10:55 PM

You need to build ad-Hoc reporting

PFA Sample

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
ad-hoc reporting.qvw
367 KB
652 Views
0 Likes