topic Re: Expression Help in QlikView

Expression Help

tamilarasu — Mon, 29 Jun 2015 02:27:31 GMT

I have a data source and needs to calculate the count of prefix's for each customer. In that, I have two classification named as 900 and 901. If the classification is 900, then Count should be 1 (No matter how many lines in the source) and no need to show material. If the classification is 901, then each line should be displayed in the chart with material. I have tried some expression where the result is fine but for 900 it showing all the records (Which is not necessary) Please see the sample and guide me.

Many Thanks.

Re: Expression Help

sunny_talwar — Mon, 29 Jun 2015 02:56:30 GMT

Not sure if I understand what you are trying to do? In the image you attached, there are Table = 900, but you are saying those are fine? How are the 900 in green part different from 900 in the red??

Re: Expression Help

jagan — Mon, 29 Jun 2015 02:59:17 GMT

Hi,

You Sno and Sales columns have repeating values so you are getting the duplicate rows, to overcome this move Sales column as expression like Sum(Sales). and remove the Sno from the dimension.

Hope this helps you.

Regards,

jagan.

Re: Expression Help

sunny_talwar — Mon, 29 Jun 2015 03:00:57 GMT

Trying to do this???

Removed two dimensions: S.no. and Sales (because they made each row unique) and change the count expression to this:

If(Table = 900, 1, Count({<Table={'901'}>}Mat))

HTH

Best,

Sunny

Re: Expression Help

Mon, 29 Jun 2015 03:09:35 GMT

Remove Sno and Sales in dimentions and add one expression =Aggr(sum(Sales),Customer,Prefix,Table,Cond). You will get desired output.

Please find attached .QVW file.

Thanks,

Uday.