Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

2 datasets for one date in datastructure

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,

MT

1 Solution

Accepted Solutions
Not applicable
Author

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,

MT

View solution in original post

9 Replies
Not applicable
Author

Hi MT,

Would you have something like:

=MINSTRING(DataValue)

Kind Regards,

Miles

jagannalla
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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

Not applicable
Author

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?

Not applicable
Author

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?

jagannalla
Partner - Specialist III
Partner - Specialist III

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.

Not applicable
Author

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

Not applicable
Author

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,

MT

Not applicable
Author

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,

MT