Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to get the flag value

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?

5 Replies
tresesco
MVP
MVP

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

sunny_talwar

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"

tresesco
MVP
MVP

Absolutely, yes.

abc_18
Creator II
Creator II
Author

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.

tresesco
MVP
MVP

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

0 as "Backorder flag"