Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to have , for example, DATE: 7/10/2015 and show me exactly what happened that day , sales of products with date of sale and customer sales records with dates. And this can be extrapolated to any registration or date type.
Sales: Count( {< id_state={7} >}id_sales)
If the dimension is date_c(8/7/15): 5 sales
If the dimension es date_gest(8/7/15): 2 sales
Correct: 2 sales
Sec: sum(sec)
If the dimension is date_c(8/7/15): 2186 sec
If the dimension es date_gest(8/7/15): 995 sec
Correct: 2186 sec
I need a DATE than show me 2 sales and 2186 sec.
Attaching a document to see exactly what i Need.
Thank you!!!
Take a look at this example:
Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/
-Rob