topic Re: Connect field with integer and date value in QlikView

Connect field with integer and date value

Tue, 27 May 2014 10:56:02 GMT

Hi everyone,

I would like to connect somehow field with numeric and date value. I have table that containig integer value of business plan per month (like on the picture below), and date field in QlikView that containing month value like ('jan','feb','mar','apr'...) (picture 2)

What I want is if current month is may to load only value of January, February, March, April and May or to control this through expression?

Second request (more important for me) is when user click on month to show him only value from January (1000), and if usere click on january and April to show him January + April (1000 + 2500)?

Has someone done something similar?

Any advice is appriciated

Tnx

Re: Connect field with integer and date value

Anonymous — Tue, 27 May 2014 11:03:34 GMT

why don't you simply rename your source headers or you can take left(field,3)

Re: Connect field with integer and date value

Tue, 27 May 2014 11:09:23 GMT

I think you are best to load the entire dataset and only sow the information you require. From looking at your example, perhaps the use of the crosstab feature should allow you to load the data into a more appropriate, usable format for linking.

Once done, link the columns by renaming the fields.

your second, more important request can then be done by inserting into a textbox =sum(Amount), which because of the magic of qlikview will only show the results you select (or all if none are selected)

Re: Connect field with integer and date value

Tue, 27 May 2014 11:09:34 GMT

Actually table with business plan value is in Navision, I make this only to explain better.

Re: Connect field with integer and date value

Tue, 27 May 2014 11:12:03 GMT

Tnx Rick,

I will try to solve my problem like you've explained me