topic Re: Different Result for same expression in TextObject and Chart in QlikView

Different Result for same expression in TextObject and Chart

phil-ebm — Mon, 25 Apr 2016 07:06:33 GMT

Hallo Community

I have a problem and at the moment no more ideas how I can solve it or where/what the real problem is.

I use following expression in a text object and in a straight table:

=Count({<$(=vSetAnalysisPosTyp1)>} HU)

text object -> this is the right result

straight table

But at the end i have for the same selection two different results

I hope someone can help me.

Why I get different results for the same expression? How I can find the right result in the straight table.

Regards

Philipp

Re: Different Result for same expression in TextObject and Chart

MayilVahanan — Mon, 25 Apr 2016 07:10:50 GMT

Could you please post a sample file to verify the expression.

Re: Different Result for same expression in TextObject and Chart

marcus_sommer — Mon, 25 Apr 2016 07:11:46 GMT

The reason will be that your expression within the table will be consider their dimension while within the textbox it will be calculated globally. In your case I assume that you used dimensions which are from more then one table and which are not be associated in the right way so that the table-dimensions are blown up.

- Marcus

Re: Different Result for same expression in TextObject and Chart

phil-ebm — Mon, 25 Apr 2016 07:37:50 GMT

Here the example

Re: Different Result for same expression in TextObject and Chart

MayilVahanan — Mon, 25 Apr 2016 07:46:19 GMT

In text box, your expression is

=Count({<$(=vSetAnalysisPosTyp1)>} distinct HU)

And your chart expression is

=Count({<$(=vSetAnalysisPosTyp1)>} HU).

So please change the chart expression to

=Count({<$(=vSetAnalysisPosTyp1)>} distinct HU)

Geschäftsjahr	Monat	Gesamt HU
		32636
2016	Jun	32636

Re: Different Result for same expression in TextObject and Chart

PrashantSangle — Mon, 25 Apr 2016 07:56:50 GMT

Hi,

You are missing Distinct Keyword in chart expression.

Regards

Re: Different Result for same expression in TextObject and Chart

phil-ebm — Mon, 25 Apr 2016 09:55:18 GMT

sorry in the example i added the wrong text object.

in this new file is the text object without distinct and less hus then in the straight table

Re: Different Result for same expression in TextObject and Chart

MayilVahanan — Mon, 25 Apr 2016 10:17:18 GMT

Instead of HU , try like below in chart

=Count({<$(=vSetAnalysisPosTyp1)>} [HU Pos])

Chart is calculates based on dimension like Year and Month. So there is duplication will occur.

Text box is calculate overall (without any dimension)

Re: Different Result for same expression in TextObject and Chart

Mon, 25 Apr 2016 10:47:44 GMT

Your expression is different in the chart and the text object,

In the expression in your chart,

add distinct to your expression,

i.e. =Count({<$(=vSetAnalysisPosTyp1)>} distinct HU)

Regards,

Anjali Gupta

Re: Different Result for same expression in TextObject and Chart

phil-ebm — Mon, 25 Apr 2016 10:55:36 GMT

but i need the HU-Field not the HU Pos Field

Re: Different Result for same expression in TextObject and Chart

phil-ebm — Mon, 25 Apr 2016 10:56:06 GMT

When I use distinct I get a different Result then in SAP where the original data is

Re: Different Result for same expression in TextObject and Chart

Mon, 25 Apr 2016 11:01:50 GMT

In the application, you have uploaded, the problem was with the different expression.

Could you upload some example with sample data from SAP for us to help you.

Regards,

Anjali Gupta

Re: Different Result for same expression in TextObject and Chart

phil-ebm — Mon, 25 Apr 2016 11:04:29 GMT

i get this data directly from sap with a bapi. when i run this bapi in the sap system there are a other result.

and sorry but i can't give you the data from our sap.

Re: Different Result for same expression in TextObject and Chart

MayilVahanan — Mon, 25 Apr 2016 11:09:42 GMT

Try like this

LOAD num(VENUM) as HU,

VEPOS as [HU Pos] ,

VBELN as Lieferung,

POSNR as [Lieferung Pos.] ,

MATNR as [HU Artikel],

PSTYV as [HU PosTyp],

1 AS Flag,

WADAT_IST as [HU Ist-Warenausgang],

UMFANG

FROM

And use "Flag" in ur expression

Re: Different Result for same expression in TextObject and Chart

PrashantSangle — Mon, 25 Apr 2016 11:27:24 GMT

Hi,

your script is incomplete therefore its difficult to understand your back end script.

can you elaborate, how you are calculating

%KeyArtikel

are you doing any process on HU table???

since issue is frequency of [HU Artikel] field from HU table and [HU Artikel] from DataTable is different.

For example

for HU 5055232

Frequency of [HU Artikel] is 1 in HU table

and Frequency of [%KeyArtikel] is 3 in DataTable

therefore your count is varying if you use distinct then it will resolve or provide more information about your script.

Hope you got my point.

Kind Regards

Re: Different Result for same expression in TextObject and Chart

phil-ebm — Mon, 25 Apr 2016 12:16:09 GMT

i actually do nothing with the table only load the HUs and then do a resident for the data-table and connect to the calender.

With %KeyArtikel i will later add article informations, but actually i just work with this three tables calender, hu and datatable

Regards