Discussion Board for collaboration related to QlikView App Development.
I know this has been discussed in many threads in this community, but I still am unable to figure out the simplest way to solve my problem.
I have dates = time(created)
I have sales = count(sales)
I would like to see on a 24 hour basis time(created) all count(distinct sales) even if there is none.
//I know there is something like this if(isnull(created),' ',sales) //If I need to make a table or bar-chart on a specific period i need to. sum(distinct if(created>=today(), sales)) //But how to get the null values? //like this? sum(distinct if(isnull(created>=today(), sales)), ' ', sales)) //this does not work.
What I have (imagine a barchart 🙂 )
what i want
You load only sets with Created when there is a Sum ?
What is the format of Created?
Suppose it‘s 0:00:
Can you try to load an inline table with 24 rows and column 1 named Created with values from 0:00 to 23:00 and column 2 with values 1 named Dummy?
Uncheck the supress zero supress null and then maybe try this
alt(sum(distinct if(created>=today(), sales)) ,0)
if(len(trim(sum(distinct if(created>=today(), sales))))=0,0,sum(distinct if(created>=today(), sales)))