topic Expression ( Dont show where the value is 0) in QlikView

Expression ( Dont show where the value is 0)

everest226 — Sat, 16 Nov 2024 04:09:59 GMT

so i have a table which has 2 measure ,

1 Column Total Price

Sum({< FLAGA={'T'}>} [ABC Sold] )

2 Column FIFA 18

Sum({< FLAGA={'T'}, [Product Name] = {'FIFA 18'} >} [ABC Sold] )

I want to format column 1 that if column 2 has value 0 then do not show the value in Column 1

@sunny_talwar

Re: Expression ( Dont show where the value is 0)

Marcos_rv — Thu, 14 Mar 2019 18:32:12 GMT

half complicated what you ask, jajajaj
what you could do is a left in the script until you get a flag for your product or products, for example flag_prod,
After you add it in the set analisys, you know that if you have a fifa18 product at least one sale you had, so:}

1 Column Total Price

Sum ({<FLAGA = {'T'}, flag_prod = {1}>} [ABC Sold])

2 FIFA 18 Column

Sum ({<FLAGA = {'T'}, [Product Name] = {'FIFA 18'}, flag_prod = {1}>} [ABC Sold])

there you would only have the 2 columns you need.

Note, this flag is used to group, I suppose you must have a field like invoice number or order and within this you have the items.

regards!!!

Re: Expression and total export in excel and view apps different , Excel shows correct

everest226 — Thu, 14 Mar 2019 20:40:00 GMT

i Manage to do in expression but somehow the total is not correct but if i export in excel it is correct not sure why.

column 1

if(Sum({< FLAGA={'T'}, [Product Name] = {'FIFA 18'}> [ABC Sold] )>0,
Sum({< FLAGA={'T'}>} [ABC Sold] ))

column 2

if(Sum({< FLAGA={'T'}, [Product Name] = {'FIFA 18'}> [ABC Sold] )>0,
Sum({< FLAGA={'T'}, [Product Name] = {'FIFA 18'}> [ABC Sold] ))

Re: Expression ( Dont show where the value is 0)

sunny_talwar — Fri, 15 Mar 2019 11:41:34 GMT

You can try this

Sum({<FLAGA = {'T'}, Area = {"=Sum({<FLAGA={'T'}, [Product Name] = {'FIFA 18'}>} [ABC Sold]) <> 0"}>} [ABC Sold])

But this will only work if Area is the only dimension in your chart. If you add other dimensions, then this won't work. The other option is just this

If(Sum({<FLAGA={'T'}, [Product Name] = {'FIFA 18'}>} [ABC Sold]) <> 0, Sum({<FLAGA = {'T'}>} [ABC Sold]))