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: 
Not applicable

how to pass QV parameters to get some other report

Hi...,

I am tring to pass qlik view parameters to get some other report but not able to get the exact solution..,please find the below attachment for better understanding of my requirement ...could any one please help me to get that requirement..

Thanks & Regards,

Sh.

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can only do this with macro's afaik. See this discussion.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

Thanks for the reply , i saw the discussion that what you shared from that i came to know it is opening qvw only with existing qvw ...this case i know but my issue is when i clik on SWITCH in qvw it has to go to disply like SSRS Reports to see more data (in my QVW that what i shared Sheet 1 Switch is working fine , but i am facing error in Sheet 2 and mentioned problem also in the QVW ), Could you please check my QVW once and let me know whether i can achive that or not....

regards,

Sh.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Maybe this is what you're looking for:

= 'http://synthesis01.americas.hpqcorp.net/ReportServer/Pages/ReportViewer.aspx?/QARI/GIIA/NA_TextSearc... 1=1 '

& if(GetSelectedCount(Country) > 0, 'AND FC.PPS_Country__c in (' & Concat(DISTINCT Chr(39) & Mid(Country, Index(Country,  ' - ')+3) & Chr(39), ',' ) & ')', '')

&  if ((GetSelectedCount(CalendarYear) + GetSelectedCount(CalendarQuarter) + GetSelectedCount(Month) + GetSelectedCount(CalendarWeek) + GetSelectedCount(FiscalYear) + GetSelectedCount(FiscalQuarter) + GetSelectedCount(Day) + GetSelectedCount(FiscalWeek))>0,

' AND FC.CreatedDate between to_date('& Chr(39)&min(Day)&Chr(39)&','&Chr(39)&'MM/DD/YYYY'&Chr(39)&')' &' and to_date('& Chr(39)&max(Day)&Chr(39)&','&Chr(39)&'MM/DD/YYYY'&Chr(39)&')'  )

&  if(GetSelectedCount(product_type_name) > 0, ' and primary_path=' & Chr(39) & 'Y' & Chr(39) & ' AND DP.PRODUCT_TYPE_NAME in (' & Concat(DISTINCT Chr(39) & product_type_name & Chr(39), ',' ) & ')', '')


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

Thanks again for the reply, Actually my requirement is please find the below condition ..that is the condition

& if(GetSelectedCount(product_type_name) > 0, ' AND DP.product_type_name in ('& Concat(DISTINCT Chr(39) & product_type_name& Chr(39), ',' ) & ')', '')

in that i need to pass primary_path='Y' condition....

and the requirement is when user select product_type_name it has to filter the condition primary_path='Y' for that product_type_name, then it has to disply the result ...so i am thinking to use primary_path='Y' in the if condition ...could you plese let me know whether we have a chance to do like that ?