topic 2 datasets for one date in datastructure in QlikView

2 datasets for one date in datastructure

Mon, 19 Nov 2012 11:56:40 GMT

Hi,

I have to dataset for one date in my datastructure. In my case I want to show always the first dataset of the date in a textbox does anyone know how to do this. cause usually if you have more possible values the textbox just shows: - so how can i get the first possible value

regards,

Re: 2 datasets for one date in datastructure

Mon, 19 Nov 2012 12:02:10 GMT

Hi MT,

Would you have something like:

=MINSTRING(DataValue)

Kind Regards,

Miles

Re: 2 datasets for one date in datastructure

jagannalla — Mon, 19 Nov 2012 12:04:54 GMT

Hello,

DataSet1:

Load * , Date as DateSet1

from DataSet1;

DataSet2:

Load * from DataSet2;

- Now take the textbox and paste this expression = Concat(DateSet1,','). It comes in the string format.

- If you want Min or Max, Go with Mathmatical functions Min(DataSet1) or Max(DataSet1)

Hope it helps you..

Cheers!!

Jagan

Re: 2 datasets for one date in datastructure

Mon, 19 Nov 2012 12:05:53 GMT

ok that helped but is not really the solution because i am getting the rgb values of my dataset so if I have for example these two colors: R: 255 G: 255 B: 0 and R:82 G: 159 B: 254 it would mix up my colors

Re: 2 datasets for one date in datastructure

Mon, 19 Nov 2012 12:15:56 GMT

now my only problem is that i have to use only() within the concat but im not allowed to any idea how to solve this?

Re: 2 datasets for one date in datastructure

Mon, 19 Nov 2012 12:29:12 GMT

ok the concat() works quiet well but a couple of times the result of concat is data2|data1 instead of data1|data2 and thats just sometimes. does anyone know why?

Re: 2 datasets for one date in datastructure

jagannalla — Mon, 19 Nov 2012 12:37:10 GMT

Concat works in load order. Please make sure that you need to retrive your result in load order what you need. Otherwise please attach sample file with your data.

Re: 2 datasets for one date in datastructure

Tue, 20 Nov 2012 07:50:12 GMT

it works in load order except for one field and thats why I get instead of yellow orange. I dont know how to influence it. I can give you example data and a screenshot but I cant give you the qvw itself cause it has a lot of sensitiv data

Re: 2 datasets for one date in datastructure

Tue, 20 Nov 2012 07:56:05 GMT

here the example data and screenshot. focus on the 2010 data 2011 and 2012 is not correct yet havent worked on it. so the orange fields should be yellow and the 27.11.2010 should be also light blue.

i really appriciate you help

regards,

Re: 2 datasets for one date in datastructure

Tue, 20 Nov 2012 10:22:43 GMT

ok i just solved the problem by creating a field named priority and set for each date the priority!!! and used set analysis to show the color.

thank you all for your help

regards,