topic Re: values are not comming in QlikView

values are not comming

Wed, 25 Nov 2020 16:16:04 GMT

hi all,

i have one issue ,i have one master calender and one table.

table having schedule amount and received amount .

i am preparing drill down chart but amount and received amount values showing wrong values

please help me

thank in advance

Re: values are not comming

MK_QSL — Tue, 11 Apr 2017 07:46:50 GMT

i have one master calendar and one table.

I can see there are many tables.. It's really difficult to work on such file.

You should only provide relevant tables or provide sample data.

Re: values are not comming

stabben23 — Tue, 11 Apr 2017 08:31:43 GMT

Hi,

Your DateDim is an dataisland, its not Connected to Your datamodel.

Re: values are not comming

stabben23 — Tue, 11 Apr 2017 08:39:37 GMT

If you add a Dimension which is Connected in Your model you will get this for ex:

Re: values are not comming

Tue, 11 Apr 2017 09:22:13 GMT

hi stabben23

yes ,master calendar is not connected to data model.

we are using master calendar in so many places.thats why master calendar is not connected to data model

Re: values are not comming

Tue, 11 Apr 2017 09:23:10 GMT

thanks for reply ,

can you send that file

Re: values are not comming

stabben23 — Tue, 11 Apr 2017 09:29:32 GMT

Just change Dimension in Your file.

"yes ,master calendar is not connected to data model.

we are using master calendar in so many places.thats why master calendar is not connected to data model"

I have no idea what you are talking about here. If you want to use the calendar in this Application you have to Connect you mastercalendar.

Re: values are not comming

Tue, 11 Apr 2017 09:31:56 GMT

hi ,

your taking book date as dimension,thats wrong

we are calculating perticular financial year how much we schdule and how much we received.

Re: values are not comming

stabben23 — Tue, 11 Apr 2017 09:52:02 GMT

I'm not saying its right, I'm just showing that if you use a dimesion which is Connected you will have Expressions that is calculated. You have problem With Your DateDim which is not Connected.