Solved: Re: Pivot Table Problem (not related data) - Qlik Community

Report Inappropriate Content · ‎2011-05-25

Hi everybody,

I have a problem to get the matching objects for the budget (data is not related by the date range):

Could somebody help me please to get the correct values in the column "Buget" for

- 01/2010 --> forecast-value "20" in column "Budget"

- 02/2010 --> forecast-value "231" in column "Budget"

Attached you can find an example QVW-File and the 3 example-XLS-Sheets.

Thanks a lot.

Regards,

jup

...

Report Inappropriate Content · ‎2011-05-31

Whoops... I didn't read the topic until the end.

Well, in the last Qvw file you have this expression:

=sum(if(num([HEL_DATA_Datum > MONTH])= SAL_PLANDATEN_Budget,SAL_PLANDATEN_Budget))

This is wrong.

num([HEL_DATA_Datum > MONTH]) is a month (1-12).

SAL_PLANDATEN_Budget is a budget (dollars).

Using the if can't extract you anything.

You have to compare apples to apples .

Probably that line should read:

=sum(if([HEL_DATA_Datum > MONTH]=Num#(SAL_PLANDATEN_Monat), SAL_PLANDATEN_Budget))

If I understand the field names correctly.

Now, for the "wrong" values. It depends upon the many join you pass from table PLANDATEN (where the Budget is) to table HELIOS (where Month is). AFAICT, it makes no sense.

You should first understand what you're doing.

Probably, as a quick solution, you can do:

=Only(if([HEL_DATA_Datum > MONTH]=Num#(SAL_PLANDATEN_Monat), SAL_PLANDATEN_Budget))

View solution in original post

Report Inappropriate Content · ‎2011-05-26

hello juppinger,

i have the same problem an i'm interested of a solution too. Maybe you need here the "aggr" function, but i'm

not sure.

Does anyone have an idea ? Thanx..

Greetings,

kaushiknsolanki · ‎2011-05-26

Hi

Here is your Ans.

Have a look at the attched Document.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-26

Hi Kaushik,

very crazy - in my attached QVW-File I will not work!!!

Could you help me please again?

Thanks a lot,

jup

kaushiknsolanki · ‎2011-05-26

Hi,

Convert the month number in text as the field you are joining is a text.

try below.

text(num([HEL_DATA_Datum > MONTH]))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-26

Hey... other strange thing happens... (wrong values)

Please find the new qvw attached.

please help again

Report Inappropriate Content · ‎2011-05-27

hi togehter,

really very strange ! I downloaded your file too and do not understand that. Exactly the same thing i want to do in my application and it also doesnt work.

If someone has a solution, i would be interested too. Thank you !

Kind regards

Report Inappropriate Content · ‎2011-05-30

Please help us!

Thanks a lot,

jup

Report Inappropriate Content · ‎2011-05-30

Hi,

Please also help. How do we get our best realized simplest problem?

Are there any recommendations? Thank you.

Best Regards

Report Inappropriate Content · ‎2011-05-31

Found the matching topic...!

I also got this problem!!! 😞

could anyone help, please?