topic Re: Set analysis not bringing through data in QlikView

Set analysis not bringing through data

Thu, 12 Feb 2015 13:08:46 GMT

I have an issue with set analysis

I have cloned charts one uses this expression and it is working fine

count(distinct(if(MeterType = 'K' and ExpectedConsumption = 0 ,UnitNo)))

The other chart I have the following set analysis, the syntax seems to be OK but it is just giving me no data to display

Count(distinct{$<MeterType = {"K"} , ExpectedConsumption = {0} > } UnitNo)

What am I doing wrong. the value in ExpectedConsumption comes from SQL where it is a numeric(5,3)

alexandros17 — Thu, 12 Feb 2015 13:13:26 GMT

try with

Count({$ <MeterType = {'K'} , ExpectedConsumption = {'0'} > } Distinct UnitNo)

Gysbert_Wassenaar — Thu, 12 Feb 2015 13:18:04 GMT

Looks ok to me at first glance. Can you post a qlikview document that demonstrates the problem?

Thu, 12 Feb 2015 13:20:26 GMT

Not working sorry

Thu, 12 Feb 2015 13:21:58 GMT

how do I shrink it enough to only show certain records?

giakoum — Thu, 12 Feb 2015 13:22:44 GMT

Make some selections first and then

File --> reduce data

Thu, 12 Feb 2015 13:26:33 GMT

Check the data cleansing tab, you will see one with no data and the other with data

simospa — Thu, 12 Feb 2015 13:41:23 GMT

Hi,

changing to

count({ $<

[MeterType]={'K'}, [ExpectedConsumption]={0.000}>} DISTINCT UnitNo)

it works, so the problem is in the ExpectedConsumption format

Thu, 12 Feb 2015 13:51:17 GMT

Thanks a million, can you explain why mine was not working and yours, so so I understand exactly what the issue is

simospa — Thu, 12 Feb 2015 14:20:38 GMT

I think that the format in which ExpectedConsumption field iid not recognize as a number by set analysis, but not sure.

If you try to create a chart with sum(ExpectedConumption) as expression you get 0.000, if sum(ExpectedConumption)*1 you get 0.