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

reading var from input box and showing another in a chart according selection

Hi, I have an input box with predefined dropdown and assign the chosen option to my variable vCountry1.

Now I have a chart that looks at that value and shows the sold quantities for that selected country in a chart, per quarter, this formula works :

Capture.JPG

So far so good

Now I want to do it different and show another variable as result

Capture2.JPG

That doesnt work

The value %N is the calculation of 2 fields : [Sales Quantity S Tonne]/[Sales Quantity Tonne]

When I use that variable $(%N) in different tables it always works, I don't understand.

I tried everything : %N, $(%N), =$(%N), =%N, same result: nada.

What do I do wrong?

4 Replies
MVP & Luminary
MVP & Luminary

reading var from input box and showing another in a chart according selection

Hi,

Try using [] i.e., [%N]

Regards,

Jagan.

Not applicable

reading var from input box and showing another in a chart according selection

Hi,

I tried that as well, doesn't work either :s

MVP & Luminary
MVP & Luminary

reading var from input box and showing another in a chart according selection

Hi,

Can you attach the sample file.

Regards,

jagan.

MVP & Luminary
MVP & Luminary

reading var from input box and showing another in a chart according selection

Hi,

Check whether the variables has values using Text boxes.

Regards,

Jagan.