Discussion board where members can get started with Qlik Sense.
Hi Qlik Users,
I would like to create a graph where i can see sales by date i.e. the following:
So in the graph, one axis would be the date, by individual date, and the other two measures "Credit Sales" and "Debit Sales" would also show.
I know in my head that i should use a combo chart where Credit sales for 02.05.15 would be on positive y-axis and Debit Sales would be on negative y-axis.
My question is, how do i create the date on the x-axis? Tried using "Day(TransactionDate)" but an error appears, even when i create the graph it only shows the days and not the month.
Try with :
Day() will give you the Day in a month, i.e 1,2, ....31. Try using Date(). If you attach some sample file it would be more easier.
Hope this helps you.
If you got the answer please go this thread by giving Correct Answer.