topic Several values in a chart on the GUI - display only the first? in QlikView

Several values in a chart on the GUI - display only the first?

datanibbler — Thu, 14 Jan 2016 08:14:22 GMT

Hi,

in a chart (straight table) there are, for certain combinations of the dimension_values, several possible values to display. The values are dates, all numeric.

The one I would want displayed there is always the first one (the smallest value).

=> Is there any possibility to have only that one value so that it can be displayed?

Thanks a lot!

Best regards,

DataNibbler

Re: Several values in a chart on the GUI - display only the first?

marcus_sommer — Thu, 14 Jan 2016 08:17:35 GMT

Hi DataNibbler,

maybe with min() or rangemin()?

- Marcus

Re: Several values in a chart on the GUI - display only the first?

datanibbler — Thu, 14 Jan 2016 08:20:50 GMT

Hi Marcus,

rangemin sounds good. How would I then pass all possible values (a field from a table) to that function? Like

>> rangemin(Table_A.Date) <<?

P.S.: OK, that seems to work - funny, now it seems to work with a simple min(Table_A.Date) - just what I had tried before ...

Thanks a lot! I think we have it. I'll wait a few minutes to make sure this is right and then I'll mark your answer as correct.

Best regards,

DataNibbler

Re: Several values in a chart on the GUI - display only the first?

tresB — Thu, 14 Jan 2016 08:25:23 GMT

If it is about a single field values, min() would be ideal. Could you please explain a bit more with a small example?

Re: Several values in a chart on the GUI - display only the first?

marcus_sommer — Thu, 14 Jan 2016 08:26:15 GMT

Not quite - rangemin needs several parameters like: rangemin(value1, value2, value3). If you asked in this way I think you couldn't really fill rangemin in this way so that concat might be better, like:

subfield(concat(Table_A.Date, ',', Table_A.Date), ',', 1)

- Marcus

Re: Several values in a chart on the GUI - display only the first?

datanibbler — Thu, 14 Jan 2016 08:32:05 GMT

Hi,

the problem appears to have been a set_expression in the formula. The colleague told me that was not strictly necessary at all and without that it seems to work. So it seems that all is fine now.

Thanks a lot!

Best regards,

DataNibbler