topic Re: How to set the default value in QlikView

How to set the default value

pranubitla — Mon, 06 Mar 2017 15:40:05 GMT

Dear Experts could you please shed some light on this please

setup the default value for a below PRODUCT field in script level.
example:

I am loading list of 3 columns from spread sheet, I would like to setup a default name COUNTRY = 'USA' in my country column for Laptops only

I've all list of countries but want to set to COUNTRY = 'USA' for 'Laptops'

awhitfield — Mon, 06 Mar 2017 15:46:11 GMT

HI Pranu,

can you expand a little on what you actually mean by 'default value'?

Andy

pranubitla — Mon, 06 Mar 2017 15:56:18 GMT

I've a list box name called 'PRODUCT' I got 3 types of products

when I select Laptops I should only get USA, even though I got data like China, UK, Inida... all converted to USA,

Original Data:

Front end result should look like below

awhitfield — Mon, 06 Mar 2017 16:07:56 GMT

Use a calculated dimension for your country field in a chart e.g.

=if(PRODUCT = 'Laptops','USA', COUNTRY)

Andy

awhitfield — Mon, 06 Mar 2017 16:25:20 GMT

Glad to be able to help!

pranubitla — Mon, 06 Mar 2017 16:26:37 GMT

Really appreciated your prompt reply.