topic Not Getting Output from Expression in QlikView

Not Getting Output from Expression

Mon, 19 Sep 2011 11:01:20 GMT

Hi Experts,

This is my Expression :

Sum({<[Name]={"'='TATA'"}>}Distinct(Sales))

Expected Output : I am using this one in Chart Expression for getting output - I want data only for Tata(Means i want to filter data in expression only for Tata)

but it is showing data for every company (like Barclay,Reliance and Tata) and not filtering.

Is their any thing wrong in my Expression, i am doing??

Please suggest me right way...

Thanks in Advance.

Regards,

Gaurav Saxena

Not Getting Output from Expression

Mon, 19 Sep 2011 11:08:29 GMT

Hi, try this:

Sum({< Name={'TATA'} >}Sales)

ps, you don't need [ ] if your field does not contain any spaces, improved readability

Not Getting Output from Expression

Mon, 19 Sep 2011 12:02:23 GMT

Hi Martijn Biesbroek ,

Thanks for reply.

the expression you are saying is showing error. if i am tring to correct it then it is correct after modifying upto :

Sum({<[Name]={"='TATA'"}>}DISTINCT(Sales))

So how else how can we modify so it will filter data only for Tata.

Seeking for your response.

Thanks

Gaurav Saxena

Not Getting Output from Expression

Mon, 19 Sep 2011 12:42:01 GMT

Hi Gaurav,

Use the following expression.

Hope it helps.

Sum({<Name={TATA}>} DISTINCT(Sales))

Rgrds,

Abhinava

Not Getting Output from Expression

Mon, 19 Sep 2011 15:09:34 GMT

Hi, Can you post you qvw file?

Normally, name = {'Tata'} should work.

PS: sum distinct sales amounts is not a thing you do normally.... (instead count distinct customerId's would make sense)

Not Getting Output from Expression

Mon, 19 Sep 2011 16:24:52 GMT

I agree with you martin..

perhaps he should lose the distinct clause altogether..

Rgrds,

Abhinava

Not Getting Output from Expression

Tue, 20 Sep 2011 04:47:36 GMT

Hey ,

Thanks for response guys...

Abhinvava it still not working.

your expression is not showing error but still it is showing all records for all names.

Martijn my data source is excel files from local machine so i can not send qvw file.(Because is will not show data)

Expression :Sum({<Name={TATA}>} DISTINCT(Sales)) is not filtering data for Tata.

Is their any other thing that i have to do and missing ?

Thanks

Not Getting Output from Expression

Tue, 20 Sep 2011 05:05:09 GMT

Hi Gaurav,

Plz check ur data model to see if the fields Name and Sales are linked correctly.

Secondly, there is no use of distinct clause for calculating sales.

If you want to have distinct sales use the distinct clause with the key connecting the Tables containing Name and Sales.

If it still doesn't work, there might be a problem with your data model. double check it

Rgrds,

Abhinava

Not Getting Output from Expression

Tue, 20 Sep 2011 05:08:45 GMT

Hey,

Now it's working actually the problem is with it's field name. it is 'NAME' and i was used 'Name'.

Thanks Abhinava

Thanks you very much to all for response.

🙂