topic Re: Fix a specific value in a column in QlikView

Fix a specific value in a column

realpixel — Mon, 25 Mar 2013 17:07:04 GMT

Hello,

I have a board with dimension, I want to fix a column with a specific value without filter.

1 - In column [SEC] there is a different code IAER, IMAR, etc. I want to see only IMAR row but I don't want to put a filter to choice with different value (IAER,IMAR,etc), I don't know if there is a possibility to fix a specific value?

SOC	SEC	Total Fac	Total
SV	IAER	1330000025	1000
SV	IAER	1330000026	2000
SV	IAER	1330000027	3000
SV	IAER	1330000028	4000
SV	IAER	1350000279	5000
SV	IMAR	1330000019	6000
SV	IMAR	1330000017	7000
			28000

2 - I want to have the sum of the column [Total Fac]. In this column there are 7 rows, it's possible the sum of this column (total = 7)?

Re: Fix a specific value in a column

Anonymous — Mon, 25 Mar 2013 17:31:49 GMT

1. Is SEC column a dimension? If yes, use this as calculated dimension, and use suppress when value is null
aggr(only({<SEC={'IAER'}>} SEC), SEC)

2. Use this expression:
if(dimensionality()=0, count(distinct "Total Fac"), sum("Total Fac"))

Regards,

Michael

Re: Fix a specific value in a column

realpixel — Mon, 25 Mar 2013 18:06:20 GMT

Thank you for reply.

1 - SEC column is dimension but when I add aggr(only({<SEC={'IAER'}>} SEC), SEC) and suppress when value is null nothing happens

SOC	Service	Total Fac	SECT	Total	if(dimensionality()=0, count(distinct "Total Fac"), sum("Total Fac")
SV	DIVS	1330000025	IAER	1000	-
SV	DIVS	1330000026	IAER	1001	-
SV	DIVS	1330000027	IAER	1002	-
SV	DIVS	1330000028	IAER	1003	-
SV	DIVS	1350000279	IAER	1004	-
SV	SRV1	1330000019	IMAR	1005	-
SV	TRST	1330000017	IMAR	1006	-
				7021	-

2- I use the expression if(dimensionality()=0, count(distinct "Total Fac"), sum("Total Fac")) same thing no result in the new column

Re: Fix a specific value in a column

Anonymous — Mon, 25 Mar 2013 18:11:34 GMT

1. It was SEC in you 1st screenshot, and now you show SECT. Relpace in calculated dimension:

aggr(only({<SECT={'IAER'}>} SECT), SECT)

2. I'm guessing your field name and expression. What is the expression there now, before my suggested change? Is it a straight table?