topic Re: Displaying all data with no curernt selection in QlikView

Displaying all data with no curernt selection

Wed, 01 Oct 2014 17:38:29 GMT

Hi All,

Am working on Dashbaord for operation where I have filter by Fiscal Year, Month, Week, Day for which am using List boxes and StartDate and EndDate parameters for specific day selections . Right now when I have no data for selected date am displaying all data in the system till date, where as I would like to see blank data upon that data selection like weekends and holidays..

Any help would be appreciated.

Thanks!!

Re: Displaying all data with no curernt selection

Wed, 01 Oct 2014 17:45:29 GMT

Hi,

You can include some conditions like below in the script for all the values

=if(isnull(value),'no data',value)) as value

hope it helps..,if possible send a sample

Kiru

Re: Displaying all data with no curernt selection

jaimeaguilar — Wed, 01 Oct 2014 17:50:44 GMT

Hi,

You can use calculation condition in your objects, so if nothing is selected the chart(s) will not calculate, something like this, you'll need to type in calculation condition:

=GetSelectedCount(Field1)>0 and GetSelectedCount(Field2)

regards

Re: Displaying all data with no curernt selection

Wed, 01 Oct 2014 20:56:23 GMT

Hi,

At what level the calculation condition should be, in sheet object I see calculation condition in General, Dimension, Expression tabs.

Re: Displaying all data with no curernt selection

jaimeaguilar — Wed, 01 Oct 2014 21:14:01 GMT

I think it shoud be at object level so you can control which charts/object get calculated depending on your selections.

Also, in your case the calculation condition should consider Fiscal Year, Month, Week, Day (according to your original post). What you should decide is if all fields should have selections in order to calculate the objects. Otherwise, your calculation condition can be defined with ORs

regards

Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 15:30:44 GMT

Am able to get calculated condition work for the fields I pull from SQL Query but like for fiscal month I have some expression behind in Sheet to display month as varchar. Not sure how would I call this expression in this calculated condition???

And also StarDate and EndDate are variables, how would I call these variables in this calculated condition???

Thanks in advance!!

Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 15:50:03 GMT

I got the variables to work but when I select the weekend or holiday, the dates are not displayed in current selection and also the charts show all the data till date..
Is their any way I can get rid off weekend and holidays in calendar object which is using variable.?

Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 15:58:06 GMT

Hello Sandhya ... I am little lost ... if you have a set based on the date i assume your chart should show zero for the no data date selection ? will it be possible for you to upload a sample document or give some sample data ..

Re: Displaying all data with no curernt selection

jaimeaguilar — Thu, 02 Oct 2014 16:10:26 GMT

I think you may need to show/hide conditions together with maybe buttons so you can trigger your selections after entering values in variables. However, it would be better if you could upload a little sample in order to help you

regards

Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 16:21:08 GMT

Thanks for responding.

Am attaching a screen shot what I see when I select holiday.

Re: Re: Displaying all data with no curernt selection

jaimeaguilar — Thu, 02 Oct 2014 16:40:27 GMT

Like I told you, you may need to combine calculation conditions (using getselectedcount() ) and using variables and buttons to enable/disable the calculation condition,

take a look at the example. It's the general idea, but you can adapt it to your case,

regards

Re: Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 17:03:20 GMT

looks like your start and end date are variables ... can you provide your expression in the chart.

Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 17:12:34 GMT

That condition works for Start Date and End Date variables.

Can I get the same condition like that for Year and expression(which is calculating fiscal month)

Re: Displaying all data with no curernt selection

jaimeaguilar — Thu, 02 Oct 2014 17:26:42 GMT

In the case of Year and Expression what do you want to limit? is it the number of Years selected or is it something else?

If it's just the number of years selected you can use getSelectedCount(Year) > Number, so you force the user to select n number of Years in order to fulfill the calculation condition

Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 17:34:58 GMT

Right now am using condition as this

=sum({$<Date={">=$(=vStartDate)<=$(=vEndDate)"}>} Sales)

How do I write the same for year and month ??

Re: Displaying all data with no curernt selection

Thu, 02 Oct 2014 19:36:20 GMT

I did try with Buttons and Set Variables as you said but didn't work for me.

Re: Displaying all data with no curernt selection

jaimeaguilar — Tue, 07 Oct 2014 14:35:43 GMT

hi,

besides the screenshot, could you please upload a sample? It would be better to help you that way,

regards