topic Re: Keeping selection list even if no values in QlikView

Keeping selection list even if no values

Anonymous — Thu, 29 Oct 2015 20:23:12 GMT

Best regards

I have a situation in which I as a graphic filter a list box type date. Also I have another list box to Town. When you select a date range for a given city, it makes me o one graphic without problem. When I select another city maintaining the same date range graphics draw another curve deselected date range. This is logical because no data for that city at that date range. In any way I require that the graph is maintained for the same date range placing 0 in each of the selected days.

If the city has data

If the city has no data: Graph with another date range where he found data (required to maintain the same level of previous dates)

Thanks in advance and sorry if the question is elementary.

Re: Keeping selection list even if no values

settu_periasamy — Fri, 30 Oct 2015 01:54:31 GMT

Hi,

You can try to Lock the List Box after selected the Date Range

You can use the date range in your expression using the Set analysis

=Sum({<DateField={">=$(=vStartDate)<=$(=vEndDate)"}>}Sales)

you can set the Start Date and EndDate value using the Variable

Re: Keeping selection list even if no values

jagan — Fri, 30 Oct 2015 02:16:51 GMT

Hi,

Try unchecking Supress zero values and Supress Missing options in

Chart Properties -> Presentation Tab

Even it is not working, then you have insert 0 values records for that city and that date then only you can display 0 for those missing dates.

Hope this helps you.

Regards,

Jagan.

Re: Keeping selection list even if no values

Anonymous — Fri, 30 Oct 2015 13:46:31 GMT

Thanks for your help.

Could you please tell me how to set the variables?. I´m just a end user and I do not know so much about programming.

Re: Keeping selection list even if no values

Anonymous — Fri, 30 Oct 2015 13:53:14 GMT

Jagan, thank you very much for your answer. I tried it and it continues the same.

Regards

Re: Keeping selection list even if no values

swuehl — Fri, 30 Oct 2015 16:00:11 GMT

As you said, it's QV standard associative DB behaviour what you've observed.

If you absolutely want to keep the dates, I think you need to uncouple the dates selection from your city selection.

Maybe you can do this using variables as suggested, another option might be alternate states.

In attached sample, I created an alternate state in document properties, set the list box for date selection to that state (and added some stuff to give the users hints if the dates are available in current city selections or not, but without changing the date selection state, so it's not necessary for the demo).

City list box is in default state.

The chart is also set to alternate state, Date is used as dimension.

Then one expression:

=Sum({$<Date= p({AS}) >} Value) +sum(0)

A little bit complex, but your request is outside QV default behaviour, hence the extra-work.

Hope this helps.

Re: Keeping selection list even if no values

jagan — Mon, 02 Nov 2015 03:06:46 GMT

It should work, can you share the sample data.

Regards,

Jagan.

Re: Keeping selection list even if no values

Anonymous — Tue, 03 Nov 2015 13:37:00 GMT

swuehl, thanks for your answer.

I do not really know how to set a variable and did not received any attached example. Anyway I have a personal licence so I could not open any .qwv file from anotther person.

I just applied the expression you suggested to me and it works that I need it even without setting any parameters in document properties and list box !

I really appreciate your help.

Re: Keeping selection list even if no values

Anonymous — Tue, 03 Nov 2015 13:42:11 GMT

Hello jagan.

Thank you very much for your interest and help.

I could get the solution from swuehl suggestion.

Regards