topic Re: How to get the flag value in QlikView

How to get the flag value

abc_18 — Wed, 07 Mar 2018 10:02:18 GMT

Hi,

In my report,dashboard I need to distinguish the data as 'All order' and 'Backorder'

In the fact table I have added one line

1 as 'Backorder flag'

now I need to create a inline table so that user can select the data from drop-down

load * inline

%source source

0 All orders

1 Backorder

how to link fact table and inline table in this case?

Re: How to get the flag value

tresB — Wed, 07 Mar 2018 10:09:10 GMT

May be you just have to create the inline load like this?

load * inline [

"Backorder flag" source

0 All orders

1 Backorder

]

And a small correction in fact table like:

1 as "Backorder flag" // double quotes instead of single

Edit: corrected

Re: How to get the flag value

sunny_talwar — Wed, 07 Mar 2018 10:30:29 GMT

Shouldn't it be this

load * inline [

"Backorder flag", source

0 All orders

1 Backorder

];

or change the other side like this

'Backorder' as "Backorder flag"

Re: How to get the flag value

tresB — Wed, 07 Mar 2018 10:36:00 GMT

Absolutely, yes.

Re: How to get the flag value

abc_18 — Wed, 07 Mar 2018 10:53:48 GMT

Hi Tresesco,

Thanks for your response.

I did the same, but in front end while selecting values from drop-down box, '1' is appearing as default value and another one is 'undefined' similar as no data.

But I need to show All orders vs Backorders data.

Re: How to get the flag value

tresB — Wed, 07 Mar 2018 11:06:01 GMT

Have you ever loaded the fact table with '0' flag? Like:

0 as "Backorder flag"