topic Re: Remark missing in QlikView

Remark missing

tracycrown — Tue, 24 Nov 2020 15:32:32 GMT

Dear Sir/Madam

Kindly help to advise why remark column cannot be shown.

Thank you, Tracy

Re: Remark missing

edwin — Tue, 24 Nov 2020 15:56:02 GMT

this is because multiple values of Remark field is possible.

maybe the remarks column needs to be further calculated?

Re: Remark missing

MayilVahanan — Tue, 24 Nov 2020 16:02:24 GMT

Hi @tracycrown

Try with intervalmatch concept for your data.

PFA

Re: Remark missing

edwin — Tue, 24 Nov 2020 16:06:05 GMT

if you move your calculated Grade to the dimension instead of the expression it will work

Re: Remark missing

edwin — Tue, 24 Nov 2020 16:06:32 GMT

also set it as ignore when null

Re: Remark missing

tracycrown — Wed, 25 Nov 2020 03:25:43 GMT

Hi Mr MayilVahanan

Thanks for your kind advice, it seems to me that the problem of remark has been solved but it creates another problem in the Profit Plan table, some data are missing for Product 20001 ?. Please help again.

I sincerely thanks you for your kind effort in resolving many of my problems but I am wondering why you stop answering further query after I accepted as solution. You are such a knowledgeable and experienced teacher and I have a lot to learn from you.

Thanks for your continuous support, Tracy

Re: Remark missing

tracycrown — Wed, 25 Nov 2020 03:38:38 GMT

Dear Mr. Edwin

Thank you so much for pointing out my issue and enclosed with a PNG file. You are so special as most of the problem solvers or advisors just helped to solve the issue without explaining WHY ?.

Your method has solved my problem but I cannot show two Grades (Dimension & Expression) in one report, is there a better way to hide the Grade in dimension ?.

Thank you very much, Tracy

Re: Remark missing

MayilVahanan — Wed, 25 Nov 2020 04:10:29 GMT

Hi @tracycrown

In that case, we can change inner join to left join to fix the problem.

Left Join
IntervalMatch(Price, Product)
LOAD Price_Lower, Price_Upper,Product Resident ProfitPlan;

Join
LOAD * Resident Sales;

DROP Table Sales;

Re: Remark missing

tracycrown — Wed, 25 Nov 2020 04:56:56 GMT

Dear Mr MayiValhanan

Thank you so much for your kind advice, it works now.

I came to know that it works if you loaded Sales.xlxs before Profit Plan.xlxs and it will not work if I arranged the other way around, can I say the sequence of loading is important ?.

I am also wondering whether you still can see my further queries if I click "Accept as Solution". If you cannot see, then I will feedback to Qlik to improve their system.

Thank you very much, Tracy

Re: Remark missing

MayilVahanan — Wed, 25 Nov 2020 07:08:19 GMT

Hi @tracycrown

Yes.

"I am also wondering whether you still can see my further queries if I click "Accept as Solution". If you cannot see, then I will feedback to Qlik to improve their system."

<-- if you got the solution & closed the thread means, the issue resolved. Mostly, the closed thread will see for reference not for discuss further. For new queries, you can create new thread and no need to wait for same person to reply. Many talented people can reply & help you to solve the solution.

And also, you can't mark your own answer as correct / like 😉😉.

@Brett_Bleess , can you suggest your opinion ?

Re: Remark missing

edwin — Thu, 26 Nov 2020 13:24:20 GMT

Hi Tracy, thanks for the kind words. im not sure why you need the grade in the expression. when you publish your report, the user will not know whether you created a dimension or expression. having said that you can still create your expression and in presentation hide the dimension that you dont want shown.

also, if you want to call someone's attention, you should call out their name @Name. so ir shows in their notification. otherwise that person will not know that you were calling his/her attention

Re: Remark missing

tracycrown — Wed, 16 Dec 2020 02:18:08 GMT

Dear Edwin

Sorry for the late reply as I was too busy in learning QV and not visiting community so often.

Can you advise how to call out their name .@Name ?.

Many Thanks, Tracy