Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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,
KC
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.
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
KC