topic Re: Restrict data based on the field value in staright chart in QlikView

Restrict data based on the field value in staright chart

Anonymous — Tue, 28 Jul 2015 18:40:09 GMT

Hello All,

I need some help in finding a way to restrict data based on value in a field, I have a field quantity, I wanted to show the data in the straight table object where quantity > 0. Any help is highly appreciated. I tried creating an expression like

=sum({$<[Item Quantity] ={>0}>}[Item Quantity]) ,but it did not work.

Thanks

Heera

Re: Restrict data based on the field value in staright chart

ramoncova06 — Tue, 28 Jul 2015 18:46:30 GMT

try using quotes inside of the filter

=sum({$<[Item Quantity] ={">0"}>}[Item Quantity])

Re: Restrict data based on the field value in staright chart

Kushal_Chawda — Tue, 28 Jul 2015 18:50:17 GMT

=Sum(if([Item Quantity] >0,[Item Quantity] ))

Re: Restrict data based on the field value in staright chart

maxgro — Tue, 28 Jul 2015 18:54:20 GMT

>0 is a search and it needs double quotes ">0" (it works with single too '>0')

Re: Restrict data based on the field value in staright chart

Anonymous — Tue, 28 Jul 2015 18:55:37 GMT

Thanks Ramon for the reply, however my data still showing records with quantity = 0

Re: Restrict data based on the field value in staright chart

Anonymous — Tue, 28 Jul 2015 18:56:42 GMT

Kush,

I tried using this logic, its not filtering the data with quantity = 0.

Re: Restrict data based on the field value in staright chart

ramoncova06 — Tue, 28 Jul 2015 18:58:40 GMT

the quotes should work, do you have items with null quantity ?

Re: Restrict data based on the field value in staright chart

Kushal_Chawda — Tue, 28 Jul 2015 19:00:01 GMT

Please post the sample app

Re: Restrict data based on the field value in staright chart

Anonymous — Tue, 28 Jul 2015 19:00:09 GMT

Massimo,

I used double quotes , but I could get the desired result. I wanted to show the data in chart where quantity >0.

Re: Restrict data based on the field value in staright chart

Anonymous — Tue, 28 Jul 2015 19:05:06 GMT

No it doesn't have, its either >0 or less <0.

Re: Restrict data based on the field value in staright chart

maxgro — Tue, 28 Jul 2015 19:10:31 GMT

field name? case?

Re: Restrict data based on the field value in staright chart

sasiparupudi1 — Tue, 28 Jul 2015 19:12:05 GMT

May be you need to round [Item Quantity] to 0.

try round ([Item Quantity],0)

Re: Restrict data based on the field value in staright chart

Anonymous — Wed, 29 Jul 2015 13:15:11 GMT

Kush,

I am attaching an example here. In the attached file I don't want to see record C in my resultant set as it as quantity =0. Please suggest me if there is way I filter it out at the dimension level.

Thanks

Heera

Re: Restrict data based on the field value in staright chart

maxgro — Wed, 29 Jul 2015 16:42:55 GMT

see attachment

Re: Restrict data based on the field value in staright chart

Wed, 29 Jul 2015 18:10:18 GMT

sum({$<[Item Quantity] =e({0})>}[Item Quantity])try this

Thanks

Sai