Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
In Input-box drop-down, need to hard to 2 string values Created Date and Completed Date.
So that I can make the date dynamic for both created and completed.
Users should select a value either created or completed date from Date Type Inputbox and then based on selection data should display.
I am having difficulties in getting drop-down values
Created Date
Completed Date
I tried expression =Concat(('Created Date' & chr(13) & 'Completed Date'),',') but not working.
See the creenshot
Actually - according to the online help with QlikView it is not language dependent ... it should be semicolons ... so I don't know why it doesn't work for you....
This is according to the help:
It is necessary to separate the values with semicolons ;
If you have two different fields and you want to show each of them on it's separate line in a drop-down and the fields return a distinct value when they are used you could simply do this:
= [Created Date] & ';' [Completed Date]
or to make sure you get two distinct values always:
= Min( [Created Date] ) & ';' & Min( [Completed Date] )
or if a set expression helps you pick out those two particular distinct values:
= Min( {<ID={1001}>} [Created Date] ) & ';' & Max( {<ID={1001}>} [Completed Date] )
Hi Petter,
These 2 Created Date and Completed Date are not fields. These are hardcoded string which I just want to display to users and based on there 2 values I can set expression.
So just Imagine, In input list box I want to display 2 values
Computer
Laptop
There values are not coming from anywhere I want to hardcode and display in list box.
Then you simply hardcode them in your in your Variables tab in Document Properties like this:
Hi Petter,
Not getting expected result. Values are not displaying in drop-down format.
Both the values are getting displayed in one line.
See the Screenshot
Then the semicolon is due to my Windows settings and that semicolon is used as a separator value. So you will have to replace the semicolon with whatever separator is used in your language settings.... maybe comma like in US? I can only guess
Actually - according to the online help with QlikView it is not language dependent ... it should be semicolons ... so I don't know why it doesn't work for you....
This is according to the help:
This one works:
Created Date;Completed Dte