Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi MT,
Would you have something like:
=MINSTRING(DataValue)
Kind Regards,
Miles
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
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
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?
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?
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.
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
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
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