Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can only do this with macro's afaik. See this discussion.
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.
Maybe this is what you're looking for:
& 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), ',' ) & ')', '')
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 ?