topic Re: Status in QlikView

Status

dseelam — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Please check attachment, would like to create a filter by status using the same expression in the straight table

Re: Status

vishsaggi — Mon, 21 May 2018 14:24:39 GMT

Did not get you what you want to see in your sheet as an output?

Re: Status

dseelam — Mon, 21 May 2018 14:28:18 GMT

Hey Vishwa,

Thanks for the reply, would like to create a filter by status using the same expression in the straight table

Re: Status

vishsaggi — Mon, 21 May 2018 14:43:58 GMT

Try this in your listbox expr:

= if(Item.STATUS_COMP='P',Item.STATUS_COMP,

if(Aggr(sum(ASCP.DMND), ASCP.ITEM, ASCP.ORG) > 0,

if(Aggr(sum(ASCP.ON_HAND-ASCP.DMND), ASCP.ITEM, ASCP.ORG) < 0,'A','S'),'P'))

Re: Status

dseelam — Mon, 21 May 2018 14:48:03 GMT

Vishwa,

this is what happening when I select 'A ' from filter

Re: Status

sasiparupudi1 — Mon, 21 May 2018 14:52:12 GMT

if(Item.STATUS_COMP='P',Item.STATUS_COMP,

IF(Aggr(sum(ASCP.DMND),ASCP.ITEM,ASCP.ORG)>0,if(Aggr(sum(ASCP.ON_HAND-ASCP.DMND),ASCP.ITEM,ASCP.ORG)<0,'A','S'),'P'))

Re: Status

dseelam — Mon, 21 May 2018 14:56:10 GMT

Hello Sasi,

It is the same expression what Vishwa posted it's giving me wrong selections when I select something from the filter as the screenshot above.

thanks

Re: Status

sasiparupudi1 — Mon, 21 May 2018 15:03:36 GMT

May be try

=If(Item.STATUS_COMP='P',Item.STATUS_COMP,

If(Aggr(sum(ASCP.DMND),ASCP.ITEM,ASCP.ORG)>0 AND Aggr(sum(ASCP.ON_HAND-ASCP.DMND),ASCP.ITEM,ASCP.ORG)<0,'A','S'))

Re: Status

vishsaggi — Mon, 21 May 2018 15:08:40 GMT

Can you break down your requirement for status A, P and S please. There is something to be tweaked around your if conditions. Please break down individually and let us know so that we can rebuild the expressions. Like what is the condition to get A, P and S accordingly.

Re: Status

dseelam — Mon, 21 May 2018 15:09:54 GMT

Tried it seems like a glitch see attached if I select 'A'

When I select 'S', 'P' is working fine

Re: Status

kaushiknsolanki — Tue, 22 May 2018 06:04:01 GMT

Hi,

The best way to create the filter is at script level,

You can create an aggregated table and include your condition to find the right status and use that field as filter on sheet.

Regards,

Kaushik Solanki

Re: Status

dseelam — Wed, 23 May 2018 14:00:49 GMT

Thanks Koushik, I will try it