Discussion Board for collaboration on QlikView Scripting.
My problem is this:
I need to create a table with 2 dimensions, when one of the dimensions need to be created by using "Group By" (meaning, need 2 other dimensions in itself in order to be calculated).
I thought about creating and calculating the first "grouped by" dimension by the script, and then using that field as a dimension in order to create my desired table.
I'm using the following in my script:
app_id_click as app_id,
text(Date(rec_date_click)) AS daily_click_date,
count( Distinct clickviewAction) as App_daily_Clicks
Group by (date(rec_date_click)), app_id_click;
the Script loads fine with no issues, but the results I'm getting are somehow incorrect...
Can you please:
A. Point out if you notice anything wrong with the script
B. Tell me if you know of an easier way of creating my histogram?
I suspect your rec_date_click is Timestamp. So please use Floor function to truncate the time and like below.
In the UI design please use required data format
Floor(rec_date_click) AS daily_click_date,
Group by (Floor(rec_date_click)), app_id_click;