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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two differents field date


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!!!

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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