Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

creating list box based on stright table expression


Hi all,

I have already created stright table claims and it contains dimensinos like pol_no,claim_no and expressions like

incurred_amount=(setanalysis expression)

indicater(Y/N)-if(incurred_amount>100,'Y','N')

i need to create list box based on indicater(Y/N) if i click on 'Y' then it need show in stright table related 'Y' indictater.like that for 'N' also

but am trying in list box expression with (if(incurred_amount>100,'Y','N')) but it is showing nothing in as list box values.

can you any suggestion for that?

10 Replies
Partner
Partner

Re: creating list box based on stright table expression

qhy don't you use a Dropdown box within your straight table for indicater(Y/N). no other listbox is necessary.

your solution for the listbox has no connection to your datamodel. what do you expect? 2 lines (one Y, one N?)

I would try with an Inline Code,but with Connection in datamodel to other tables

Partner
Partner

Re: creating list box based on stright table expression

Hi,

You can add an extra line in your script:

If(Incurred_amount > 100,’Y’,’N’) as YourField

And add this field as a list box to your app. This gives you more flexibility instead of using an expression in the list box. If you want to stick with using an expression to the list box try the following expression:

= If(Incurred_amount > 100,’Y’,’N’)

Not applicable

Re: creating list box based on stright table expression

thanks for replay but it is not workinh when i write in expression

Partner
Partner

Re: creating list box based on stright table expression

Strange. Can you provide me with a screenshot of your expression?

Not applicable

Re: creating list box based on stright table expression

Can you post the qvw?

Not applicable

Re: creating list box based on stright table expression

it have 300 MB file i can not post?

Not applicable

Re: creating list box based on stright table expression


sorry i can't send any data

Not applicable

Re: creating list box based on stright table expression

Hi Sanjeev,

Can you replace the incurred_value with the set expression in the IF statement?

eg: if(set expression>100,'Y','N')

Just try if this works, if not then maybe the problem could be there.

Not applicable

Re: creating list box based on stright table expression

it is not working