topic Re: Filter in QlikView

Filter

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

Hi, I need to create a filter in such a way that It should convert the complete data of sales from thousands to million means for example 10 k to 0.1 M it should convert

Re: Filter

arpitkharkia — Fri, 26 Apr 2019 09:23:09 GMT

Hi,

1. Create an inline table for the list box.

2. Write your expression as

if(GetFieldSelections(YourList)='Thousand',"Thousand Format Expresion")

I hope its clear! 🙂

Re: Filter

Sameer9585 — Fri, 26 Apr 2019 09:43:22 GMT

Can you help me in clear? I'm not getting it.

Re: Filter

arpitkharkia — Fri, 26 Apr 2019 09:51:35 GMT

PFA

Re: Filter

Sameer9585 — Fri, 26 Apr 2019 09:58:30 GMT

I am not clear at the expression step not at the Inline list

Re: Filter

arpitkharkia — Fri, 26 Apr 2019 10:02:35 GMT

=if(GetFieldSelections(List)='Thousand',
Num(YourExpressionHere/1000,'#######K'),
if(GetFieldSelections(List)='Million',
NUm(YourExpressionHere/1000000,'########M')))

which part?

Re: Filter

Sameer9585 — Fri, 26 Apr 2019 10:26:41 GMT

Where I should type this expression? That's the main doubt

Re: Filter

arpitkharkia — Fri, 26 Apr 2019 10:29:31 GMT

Wherever you want to show the values. In chart/text box etc.