topic Conditional statement for a Straight table? in QlikView

Conditional statement for a Straight table?

hkg_qlik — Tue, 07 Dec 2010 00:41:25 GMT

Hi,

Currently my data in the table is as follows:

Customer Name	Credit	Balance	Current
A	$20,000.00	($52,602.64)	$31,478.17
B	$10,000.00	($45,665.92)	$0.00
C	$20,000.00	($31,876.00)	$0.00
D	$25,000.00	$0.00	$0.00
E	$150,000.00	$0.00	$0.00
F	$10,000.00	$0.00	$0.00
Total	$235,000.00	($130,144.56)	$31,478.17

--> I want ti make it look like this. (I want to get rid of all the records where Balance = 0.00 and Current = 0.00)

Let me know how can I get the below table every time based on the condition.

Customer Name	Credit	Balance	Current
A	$20,000.00	($52,602.64)	$31,478.17
B	$10,000.00	($45,665.92)	$0.00
C	$20,000.00	($31,876.00)	$0.00

Conditional statement for a Straight table?

marcel_olmo — Tue, 07 Dec 2010 00:50:26 GMT

Hey hkgandhi, what you looking for it can be solved if you use the "edit" option in the expressions tab, and you put :

if(Balance<>0, Balance)

if( Current<>0, Current)

for both expressions, and you goona get rid of all the records where balance or current are equal 0.

Hope it helps!!

Conditional statement for a Straight table?

hkg_qlik — Tue, 07 Dec 2010 01:02:41 GMT

The plan is to remove the entire row from the table if the row contains or satisfies the condition:

BALANCE = 0 and CURRENT = 0.

Conditional statement for a Straight table?

pover — Tue, 07 Dec 2010 01:32:58 GMT

In the Credit column put the expression:

if(Balance=0 and Current=0, 0, sum(Credit))

If all the expression are zero and you have the option to suppress zero values selected in the Presentation tabe then the rows will disappear.

Regards.

Conditional statement for a Straight table?

hkg_qlik — Tue, 07 Dec 2010 01:42:52 GMT

Thanks for the reply .

But its not working for me.

Conditional statement for a Straight table?

pover — Tue, 07 Dec 2010 01:48:32 GMT

What's not working? The function returns null or the rows don't disappear? It is is a problem with the function, post it. If the rows don't disappear try turning everything to null().

Regards.

Conditional statement for a Straight table?

marcel_olmo — Tue, 07 Dec 2010 09:30:14 GMT

Karl is right, it should work for you. Maybe you've something wrong in your "if" function.

Cheers!!