Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I have a problem with the quarterly balance show at the bar chart.
I normally join all the dates. Here is the code.
LOAD Date ,
month(Date) as Month,
if(len(Date)>0,'Q'&Ceil(Month(Date)/3)) as Quarter,
year(Date) as Year,
[Sr No.],
Customer_Account as [Customer Account],
[Old Customer Account],
Customer_Name as [Customer Name],
Balance,
Balance1,
Status
From
xx..\5.8.15.xlsx];
There have four dates of two months in Q3 but It only show two dates of a month in the bar chart. Let me know how to fix it.
Best Regards,
Kyaw Myo Tun
Transform the graph in a table (in the general tab properties) and verify that values really are not displayed
Dear Saccone,
Yes, It only show two dates of a month also in straight table. Let me know how to fix the problem.
Regards,
Kyaw
Can you post your doc?
how does your Dimension and expressions looks like
as i can see there are two months in Q3 with 4 Dates in total
please post more details
Hi KyawMyoTun
Can you post your qvw?
If your data is sensitive look at this post - https://community.qlik.com/docs/DOC-6075
Dear All,
My data is sensitive and I can't also download scrambling zip too. Let me explain on this. My dimensions are Customer Account and Customer Name group by cyclic & Date. Simply sum the Balance on expression because An account may have more than one Balance in a date. What I want to do is, If I select Q1, simply sum the balance by dates including in Q1(Jan,Feb,March) and want to show by each date like above bar chart. Hope to understand me.
Best Regards,
Kyaw
Please look at the attached qvw. From your description it looks like that for me:
Dear Daniel,
Sorry for late reply. But it only showed two dates(i have four dates of a quarter). Let me know, what's wrong with my chart of expression? One thing is, I don't want to calculate on Balance1.
Best Regard,
Kyaw
Hi Kyaw, it's hard to help you without your qvw. Let's try like this - put some random data into your qvw and attach it. I'm sure then we will find solution for you.