topic Re: ABOUT FILTERING in QlikView

ABOUT FILTERING

janardhan — Wed, 24 Oct 2012 11:11:18 GMT

Hi friends ,

i have some itemid like 10 ,20 ,30 ,40 ,50 ,60 ,70 . i need to pick some of them like 20 ,30 ,50 ,60.

i need to display those itemids mentioned and with their respective data.

Please help me.

Thanks in Advance

jana

janardhan — Wed, 24 Oct 2012 11:16:27 GMT

i have to dispaly in straight table or in pivot

janardhan — Wed, 24 Oct 2012 11:20:22 GMT

i am attaching the example , pls find it

janardhan — Wed, 24 Oct 2012 11:22:27 GMT

as shown in the image , i need display only OTG180 , OTG191 , OTG179

janardhan — Wed, 24 Oct 2012 12:27:35 GMT

I need to display total for selected itemids

MayilVahanan — Wed, 24 Oct 2012 12:51:31 GMT

If i understood your requirement correctly means, you want to display the

OTG180 , OTG191 , OTG179 items and its respective data alone in straight table always?? If so,

In expression ,

Try like this:

=Sum({<ItemId={'OTG180' ,'OTG191','OTG179'}>}LineAmount)

So from this, its always so the three ItemId alone in the table. If not, please try like Gysbert Wassenaar suggestion.

Regards,

R.MayilVahanan

janardhan — Wed, 24 Oct 2012 13:06:03 GMT

Thanks for ur help.....

janardhan — Wed, 24 Oct 2012 13:09:55 GMT

if u dont mine...

can i write like this in the expression

otg50 – otg175 + otg182-otg192 + otg193-otg196

MayilVahanan — Wed, 24 Oct 2012 13:20:30 GMT

Try like this

=Sum({<ItemId={'OTG182' ,'OTG193','OTG50'}>LineAmount)-Sum({<ItemId={'OTG192','OTG175','OTG196'}>}LineAmount)

Hope it helps

janardhan — Wed, 24 Oct 2012 13:31:22 GMT

Thanks Ram..