Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Each supergroup has certain number of brands which is a dimension this is data about brands launched in a certain period, i have a requiremnt that i need to show the count......when i use count(distinct brand) it shows total brand count irrespective of date so i need the count in that particular launch period.....
I have two variables vStartDate and vEndDate using which in expression i am able to sort launch date..
I am attaching the excel file which has format for the report...
Thanks and Regards,
Rohit
Hi
Something like:
count({<launchDate = {">='$(vStartDate)' <='$(vEndDate)'"}>} distinct brand)
(assuming vStartDate and vEndDate are date fields with the same date format as the launch date field).
HTH
Jonathan
Hello,
count({< SKU_Launch_Date ={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} distinct (BRAND))
I had tried thi earlier but it isnt working...
Thanks and Regards,
Rohit
if you create a text box and enter the exact text =vStartDate, does it display a date in the same format as the SKU_Launch_Date field? If yes, then my post should work for you. If it displays as a number, then your approach should work. If it displays as an expression, then you need to define the variable with a leading = sign.
Otherwise, I suggest that you post a sample of your document.
Regards
Jonathan
Sample Data ..
I meant your qvw document, rather than the source data
Jonathan
Hi,
Please find attached application.