topic Re: User Input to be used for generating a Keyword in QlikView

User Input to be used for generating a Keyword

Pulkit_Thukral — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have got the below requirement:-

Qlikview should act as a Interactive Web Page wherein user will input 3 information :-

Location of the Server-uk or germany

Environment- Production or Non-Prod

Server Role-App Server or DB Server or FTP Server

Now, i have been provided Keywords for the above metrics.

Location-If Location is germany,then first 2 characters for "Keyword" would be "S6" else "S0"

App server would be identified by "30" digits. Different digits provided for other types.

Prod Environment would be identified by a W.

Also,i have been provided IP Pool wherein all Range for IPs is provided and all used IPs list is given to me in a flat file.

Now for every new server , a new unused IP has to be assigned from the Range.

Finally qlikview should provide a Keyword(Hostname) of below format:-

Sample name - S630W0001

Server Location - UK/Germany if UK then Newport/Non-Newport (Can be cloud as well) - S6 for UK, S0 for Germany and SC for cloud

Server Role - App(30)/DB(60)/File(40)/Print(50)/FTP(10)/DC(00)

Environment - Prod Non Prod (Prod will only have W and non-prod will have TW - T)

0001-Random unused number assigned

Can this thing be achieved using Qlikview ?

Re: User Input to be used for generating a Keyword

jyothish8807 — Thu, 03 Nov 2016 14:02:08 GMT

Hi Pulkit,

This can be achieved by using input box.

Try to create 3 variable for each parameter, then customize your charts as per the value each variables will contain.

Br,

Re: User Input to be used for generating a Keyword

rupamjyotidas — Thu, 03 Nov 2016 14:20:21 GMT

Two ways:

Input Box

Input Field

This blog would help

Loading Data into Input Boxes

Re: User Input to be used for generating a Keyword

Pulkit_Thukral — Thu, 03 Nov 2016 16:05:22 GMT

Hi Jyothish,

Thanks for your help.

This has been done.

Also can you please confirm me ,how in an expression of a text box i can generate a random number from a particular range(lets say -1000 -2000) and that number should be an unused number.

and how can i create a full table of all the (Hostnames) keywords that are created using this logic as nowhere they are being stored.

Re: User Input to be used for generating a Keyword

jyothish8807 — Thu, 03 Nov 2016 16:15:27 GMT

Hi Pulkit,

You can create a random no like this in a text box:

= round(Rand() * (2000-1000 ) +1000)

Your 2nd requirement is not clear to me.

Regards