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

Conditional show without field selections

Hello,

Please see attached file as an example..

I need to be able to display objects and current field selections should not impact their conditional show. So, from the attached example, objects 1-6 should always show on the left side, while 7-9 on the right side. I am thinking that conditional show should include both sequencenumber and range field definitions (e.g. 1 and on time) but that does not work for me.

Any ideas?

Thanks!

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Conditional show without field selections

Mayil, Khaled,

thanks for your ideas. Got it to work as I wanted to. See attached file and to see it work, change ranges between on time and not on time.

Thanks!

5 Replies

Re: Conditional show without field selections

HI

Are you  expecting something attached file?

And also have doubts in your requirement. Can you say in detail?

Not applicable

Re: Conditional show without field selections

Hi,

Thanks but not quite there.

Maybe my initial requirement description wasn't good enough.

2 quadrants

1) left quadrant should display ONLY those sequencenumbers that are ON TIME

2) right quadrant should dispaly ONLY those sequencenumbers that are NOT ON TIME

I reckon I have to create 9 objects in each quadrant and then apply conditions to them.

End result should be:

left quadrant: display objects 1 - 6

riht quadrant: dispaly objects 7 - 9

Note that values in the range field can change.

Thanks

Not applicable

Re: Conditional show without field selections

Hi,

Check out Mayil's solution.

If I understood your requirement clearly, you can make your objects independent of selections by using a conditional show statement that looks something like this:

only({1}Match(sequencenumber,'1'))

Hope that helps.

-Khaled.

Re: Conditional show without field selections

HI

Check the not on time .

But make sure that, you can use only() function in conditional, then u must select any one range in it. In this attached file, you can see the demo. You can also use maxstring()/minstring() function instead of only(), but i have doubt, if no selection in range means, which objects want to display..so i put like this..

Edit:

PFA

Miss to attached.

Not applicable

Re: Conditional show without field selections

Mayil, Khaled,

thanks for your ideas. Got it to work as I wanted to. See attached file and to see it work, change ranges between on time and not on time.

Thanks!