topic Re: Chart not showing numbers in QlikView

Chart not showing numbers

Edge — Sat, 16 Nov 2024 18:58:45 GMT

Hello guys,

Below chart doesn't show a number at the end of the green line (See red circle). Any idea how can I fix this?

Below is my dimension expression:

if([Admitted Week]<=8,[Admitted Week],null())

Below is my green line expression:

=if(count(DISTINCT{$<AppAdmEnr.PROG_ACTION={'ADMT','MATR','ADRV'},[Semester Year Name]=,SemesterNO={$(=vCombined_Adm_Progn_Max_SemesterNO)}>}AppAdmEnr.EMPLID)>0, rangesum(Above(
count(DISTINCT{$<AppAdmEnr.PROG_ACTION={'ADMT','MATR','ADRV'},[Semester Year Name]=,SemesterNO={$(=vCombined_Adm_Progn_Max_SemesterNO)},[Program Action Date]={'<=$(=Date(today()))'}>}AppAdmEnr.EMPLID),0,RowNo())))

Re: Chart not showing numbers

Edge — Mon, 09 Mar 2020 13:36:54 GMT

Hello guys,

Anyone have an idea bout the above?

Many thanks in advance.

Re: Chart not showing numbers

Edge — Wed, 11 Mar 2020 09:35:12 GMT

Hello guys,

could someone help with this please?

Re: Chart not showing numbers

tresB — Wed, 11 Mar 2020 10:09:39 GMT

Could you share a sample app that demonstrates the issue?

Re: Chart not showing numbers

Edge — Wed, 11 Mar 2020 10:20:23 GMT

Hello Tresesco,

Many thanks for your response. I am sorry but I can't do that. Is there any other alternative?

Regards,

Hassan

Re: Chart not showing numbers

tresB — Wed, 11 Mar 2020 11:30:01 GMT

If you are worried about data privacy, you could scramble your data and upload a sample. Check how to scramble data in qlikview

Re: Chart not showing numbers

Edge — Wed, 11 Mar 2020 11:45:21 GMT

Dear @tresB,

Many thanks for your response. Your tip is very helpful.

I have reduced the file size and I am getting an approval from my boss to upload the file here. Once I get the approval I will share it here.

Kind Regards,

Hassan

Re: Chart not showing numbers

Edge — Mon, 16 Mar 2020 06:19:38 GMT

Dear @tresB ,

Many thanks for your tip. I have attached a sample file.

Could you please take a look and advise?

Many thanks,

Hassan

Re: Chart not showing numbers

tresB — Mon, 16 Mar 2020 05:56:11 GMT

Hi,

I don't see any data nor a chart in the attached file.

Re: Chart not showing numbers

Edge — Mon, 16 Mar 2020 07:05:46 GMT

Hey @tresB ,

OOOOpseee. I have attached the wrong document. I have attached the correct one here. 🙂

Re: Chart not showing numbers

tresB — Mon, 16 Mar 2020 06:46:57 GMT

Now I see data but not the chart with the issue. Could you help trace the chart and may be select your data and save and share so that I can get quickly to the issue ?

Re: Chart not showing numbers

Edge — Mon, 16 Mar 2020 07:02:11 GMT

Hey @tresB ,

Many thanks for your help. I have tried to create a simplified view and have attached one. I hope that helps, sorry for the earlier confusing document.

Many thanks again :).

Re: Chart not showing numbers

tresB — Mon, 16 Mar 2020 07:47:32 GMT

Your max week no for entire data set is 2, however, you want the value display to be context sensitive and for your issue-chart the max week should be considered as 1 which is defined (max) by 'new' student. Hence, try your Show Value expression with similar control, like:

if(max(total {<[Student Status]={'New'}>} [Enrolled Week])=[Enrolled Week],1,0)

Re: Chart not showing numbers

Edge — Mon, 16 Mar 2020 09:11:13 GMT

Hello @tresB ,

Could you please explain more? I wasn't able to fully understand your suggestion.

Many thanks 🙂

Re: Chart not showing numbers

yassinemhadhbi — Mon, 16 Mar 2020 09:55:40 GMT

Hello,

Is this what you want you want to achieve ?

if yes write this in the show value

if(max(total {<[Student Status]={'New'}>}[Enrolled Week])=[Enrolled Week],1,0)

Re: Chart not showing numbers

tresB — Mon, 16 Mar 2020 10:55:14 GMT

Hi Hassan,

Is it working? If you confirm, I will try and explain (though I a not good at it).

Re: Chart not showing numbers

Edge — Mon, 16 Mar 2020 10:11:48 GMT

Hello @yassinemhadhbi ,

Many thanks for your response.

It is what I am looking for, but where is the show value field that you mentioned?

Regards, Hassan

Re: Chart not showing numbers

yassinemhadhbi — Mon, 16 Mar 2020 10:22:44 GMT

Expand the first expression,

you will find things like color and back ground color, the last one is show value

past the expression there

Re: Chart not showing numbers

Edge — Mon, 16 Mar 2020 10:35:37 GMT

OMG, many thanks @tresB @yassinemhadhbi .

I didn't even know about this field because the previous developer is the one who created it. Many thanks guys, you are awesome 🙂

And I have fixed it in as you can see in the attached image :). All I had to do was just adjust the show expression that was there. 🙂

Thanks Again,

Hassan