Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Create List Box

I am trying to generate a dash board which should display the total amount based on selection

My data is

Type1

Bal_Before Adj

Adjustment

Final

A

10

0

10

B

20

0

20

C

30

5

35

I need to create a List Box showing “Before Adj” and “After Adj” and

While selecting “Before Adj” I need to display Column 2 whereas while selecting “After Adj” I need column 4

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Create List Box

Create a table BeforeAfter in the load script:

BeforeAfter:

LOAD * Inline [

BeforeAfter

Before

After

];

Add a listbox for the new field BeforeAfter. Set the expression for Conditional for Bal_Before Adj to match(BeforeAfter,'Before') and set the expression for Conditional for the expression for Final to match(BeforeAfter,'After'). See attached qvw.


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: Create List Box

Create a table BeforeAfter in the load script:

BeforeAfter:

LOAD * Inline [

BeforeAfter

Before

After

];

Add a listbox for the new field BeforeAfter. Set the expression for Conditional for Bal_Before Adj to match(BeforeAfter,'Before') and set the expression for Conditional for the expression for Final to match(BeforeAfter,'After'). See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Create List Box

Thanks a Lot dear .. It Worked...

Not applicable

Re: Create List Box

Thanks a lot , it worked

Community Browser