topic Re: If Condition in QlikView

If Condition

dseelam — Mon, 13 Aug 2018 14:13:22 GMT

Hello Folks,

How to use if condition around below expression, give me item where below expression value is equal to zero

sum((ACTUAL_COST)*SHIPPED_QUANTITY)

Re: If Condition

lfholland — Mon, 13 Aug 2018 14:16:11 GMT

It should go something like this:

IF(sum((ACTUAL_COST)*SHIPPED_QUANTITY)=0,true expression, false expression)

Re: If Condition

dseelam — Mon, 13 Aug 2018 14:23:26 GMT

I need values in Straight table, Not working

Re: If Condition

lfholland — Mon, 13 Aug 2018 14:37:04 GMT

Do you have a sample qvw you can share?

Re: If Condition

dseelam — Mon, 13 Aug 2018 14:43:53 GMT

Sorry I dont have any sample QVW but you see below I want to show only rows with zero value

Re: If Condition

vishsaggi — Mon, 13 Aug 2018 14:57:10 GMT

Try this?

sum(IF(ACTUAL_COST*SHIPPED_QUANTITY = 0, Fieldused1, 0)

Not sure which field you want to sum on so just mentioned some dummy name. Replace that with your actual fieldname.

Re: If Condition

dseelam — Mon, 13 Aug 2018 15:36:09 GMT

Hello Vishwa,

It gave odd results

Re: If Condition

neelamsaroha157 — Mon, 13 Aug 2018 15:42:56 GMT

I don't think you should sum a dimension like ITEM_NUMBER. It would be easier to understand if you can provide a sample file with expected output.

Re: If Condition

vishsaggi — Mon, 13 Aug 2018 15:44:16 GMT

You cannot do a sum on your ItemNumber. Itemnumber is not a measure value right? may be you need count. Use count instead of Sum.

Re: If Condition

vishsaggi — Mon, 13 Aug 2018 15:45:14 GMT

Are you trying to count the number of items or you want sum(cost) ?

Re: If Condition

Anil_Babu_Samineni — Mon, 13 Aug 2018 15:46:50 GMT

Perhaps this?

sum({<ITEM = {"=Sum(ACTUAL_COST*SHIPPED_QUANTITY)=0"}>} (ACTUAL_COST*SHIPPED_QUANTITY))

Sum(Aggr(sum({<ITEM = {"=Sum(ACTUAL_COST*SHIPPED_QUANTITY)=0"}>} (ACTUAL_COST*SHIPPED_QUANTITY)), ITEM_NUMBER))

Re: If Condition

lfholland — Mon, 13 Aug 2018 16:01:10 GMT

Not sure if this will work with yours but you may be able to try a calculated dimension....

In this example if NetSales has a value, the dimension is a space, so all the ones with a value are grouped in a space and for the rest, it shows the item number...

Re: If Condition

dseelam — Mon, 13 Aug 2018 17:39:47 GMT

Hey Vish,

I just need show item along with sum of cost where its equals to zero only

Re: If Condition

dseelam — Mon, 13 Aug 2018 18:00:08 GMT

Hello Neelam,

Just attached samples, if you see am missing item num 1,4 7 in the QVW file all I need to see is 1,4,7 where cost is equal to zero

Re: If Condition

vishsaggi — Mon, 13 Aug 2018 18:01:35 GMT

Can you give an example of what you are expecting to see for one Item#. Give an example.

Re: If Condition

vishsaggi — Mon, 13 Aug 2018 18:04:55 GMT

In presentation tab of your chart properties uncheck supress 0 values so you can see item numbers 1,4,7. Is that what you are looking for?

Re: If Condition

dseelam — Mon, 13 Aug 2018 18:10:23 GMT

I would like to show only items with 0 values in my case, Like below

Re: If Condition

vishsaggi — Mon, 13 Aug 2018 18:21:32 GMT

Try this?

= sum({<ITEM = {"=Sum(ACTUAL_COST*SHIPPED_QUANTITY)=0"} >} ACTUAL_COST*SHIPPED_QUANTITY)

Re: If Condition

dseelam — Mon, 13 Aug 2018 19:08:02 GMT

Thanks Vishwa