topic Re: Set Expression for capturing some data in QlikView

Set Expression for capturing some data

nevilledhamsiri — Thu, 19 Jul 2018 16:51:46 GMT

Hi,

I have a table like below

Code values

77480 500

77170 1000

45150 450

78110

77450

75150

Please write a set expression to get the list of codes which carries no values.

Thanks

Neville

Re: Set Expression for capturing some data

sunny_talwar — Thu, 19 Jul 2018 16:52:55 GMT

You need this in which object? List Box? Chart?

Re: Set Expression for capturing some data

nevilledhamsiri — Thu, 19 Jul 2018 17:19:43 GMT

please do it for both list box & chart

Re: Set Expression for capturing some data

sunny_talwar — Thu, 19 Jul 2018 17:21:46 GMT

May be this for list box object

Aggr(Only({<Code = {"=Sum(values) = 0"}>} Code), Code)

For chart

Dimension

Code

Expression

Sum({<Code = {"=Sum(values) = 0"}>} Measure)

Re: Set Expression for capturing some data

nevilledhamsiri — Thu, 19 Jul 2018 17:26:13 GMT

what is meant by measure ?

Re: Set Expression for capturing some data

sunny_talwar — Thu, 19 Jul 2018 17:27:26 GMT

It is just a placeholder... I don't know what you are trying to do in a chart (at least you have not mentioned what you are looking to do in a chart)

Re: Set Expression for capturing some data

surendraj — Thu, 19 Jul 2018 17:32:29 GMT

May be this!!

In List box-->Properties-->General-->Field-->Expression-->

if(Len(trim(values)=0,Code))

Re: Set Expression for capturing some data

nevilledhamsiri — Thu, 19 Jul 2018 17:37:24 GMT

I made the expression as below which gives me even the codes with balances.I need following codes out of total list to be shown. Sorry for the trouble, please see what error I have made

78110

77450

75150

Sum({<Code = {"=Sum(values) = 0"}>}CODE)

Re: Set Expression for capturing some data

sunny_talwar — Thu, 19 Jul 2018 17:39:19 GMT

If you field called CODE or Code? Use it consistently in your expression

Sum({<Code = {"=Sum(values) = 0"}>}CODE)

Re: Set Expression for capturing some data

nevilledhamsiri — Thu, 19 Jul 2018 17:49:42 GMT

Dear Sunny,

Please see the attachment. CODE (Dimension) seems to be taken as it is at every point but could not get the results

Please see the error done

Re: Set Expression for capturing some data

sunny_talwar — Thu, 19 Jul 2018 17:56:17 GMT

Can you reload the app and save back... there is no data in the attached app

Re: Set Expression for capturing some data

nevilledhamsiri — Thu, 19 Jul 2018 18:05:52 GMT

Thank Sunny for your assistant one point after the other. You are alright. The consistently what you proposed to be made produced results in the end. I have not applied the "value" in block letters as it is loaded. Correct now. Thanks a lot

CODE	SUM(VALUE)	Sum({<CODE={"=Sum(VALUE)=0"}>}CODE)
45150	2000	0
75170	0	75170
77110	500	0
77150	1500	0
78100	200	0
78145	0	78145