Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can somebody please tell me where am i going wrong? I get a blank chart...
Check that you actually loaded the data that you're trying to show in the chart. If you need more help then please post the .qvw file so we can look at it.
Thank You. All sorted. Can you help me display this data and correct expression please?
NB! https://drive.google.com/file/d/1W3y3RBT6b5PHxTyVzZiGviyTDynE8At0/view?usp=drivesdk ------@@@@
https://drive.google.com/file/d/1wk7AUNXITIsrzoY6uDgMxMFrvc-dO7n3/view?usp=drivesdk
My Project: https://drive.google.com/open?id=1NzkGzOr4-b9gqQiRkVR_khqQYtD_pQVz
@Gysbert_Wassenaar wrote:Check that you actually loaded the data that you're trying to show in the chart. If you need more help then please post the .qvw file so we can look at it.
My Project: https://drive.google.com/open?id=1NzkGzOr4-b9gqQiRkVR_khqQYtD_pQVz
Display the total of "AUTHORISED AMOUNT" for all claims of which the "INCIDENT DATE" fell within the date range of each
Catastrophy start and end date (Excel Document 'Catastrophy Incidents'). If the "AUTHORISED AMOUNT" is R0, use the field "CLAIMED AMOUNT" as a value.
For this view, you should only include claims where the CLAIM STATUS is not equal to 'R' or 'Z'.
Use the Claims data to provide useful views.
Expression:
SUM(if(timestamp#([incident date])>=Timestamp#([Start Date]) and timestamp#([incident date])<=TimeStamp#([End Date])
and [Authorized Amount] > 0, Authorized Amount] ,
if(timestamp#([incident date])>=Timestamp#([Start Date]) and timestamp#([incident date])<=TimeStamp#([End Date])
and [Authorized Amount] =0,[Claimed Amount]))
)
I'm not going to download random files from google. You can attach your qvw documents to this discussion.
And please be clear about what you need help with. I'm not going to copy what's already explained in the book you're using.
I am willing to help, but within certain limits. My time is not unlimited and you're not paying for it. So I want to spend my time effectively.
Another limit is that I don't want to download files from sources that I don't know I can trust. If you trust random links to what appear to be google drive files that's fine. It doesn't mean that I have to. I don't see any reason why you can't attach your file to this discussion. Unless it's so big that I wouldn't want to download it anyway.
I'm not sure what your last sentence means. If you're trying to call me a fool, then you'll have to be more explicit.
Have a nice day.
Hi @yrstruly,
Thank you for being a member of Qlik Community. Please keep in mind that this community is a professional, respectful, and friendly environment for Qlik users to collaborate and assist each other. Please treat others accordingly, as many members are volunteering their own time to assist others.
Regarding file downloads and external links: for security purposes, we advise all members to attach their files directly to their community posts instead of using third-party file hosting services. As Gysbert pointed out, we recommend community members do not click on links to externally hosted files, due to the risk of viruses, malware, phishing, and other unwanted side effects.
Thank you for your understanding, and please let us know if you have any questions.
Thank you,
Jeremy
Qlik Community Team