topic Re: No data to be displayed in QlikView

No data to be displayed

Mon, 30 Sep 2013 18:12:22 GMT

Hello Experts,

I have a requirement. I have a couple of list boxes (List boxes A, B , C, D say) in a sheet. and then there are few charts (say X, Y, Z).

The problem statements is when any value is selected from List box A, Chart X shouldn't show any data even though it has relevant data to be shown. And again when any value from List Box B is selected, then Chart Y shouldn't show any data even though it has relevant data to be shown. And in any other time if none of the value is selected from either A or B, both the graph should act as usual. And if list boxes C or D is selected, the graphs should still show data.

Please help.

Re: No data to be displayed

MayilVahanan — Mon, 30 Sep 2013 18:22:40 GMT

Without view the data model and sample file, its difficult to give solutions. Can you please provide a sample file?

Re: Re: No data to be displayed

Mon, 30 Sep 2013 18:34:03 GMT

Thanks for the response.

Please find attached a sample file.

Thanks

Re: No data to be displayed

Anonymous — Mon, 30 Sep 2013 18:34:11 GMT

Bikash,

You can use Calculated Condition (or Show Condition to hide the charts completely), and use GetSelectedCount() as condition. For example, calculated condition for chart X would be

GetSelectedCount(A)>0

or even simply GetSelectedCount(A) - it implies ">0"

I hope you'll figure out the rest.

Regards,

Michael

Edit: I got it just the opposit way, the condition for X is GetSelectedCount(A)=0 (that is, no selections)

Edit 2: See attached, I added calclution conditions to charts X and Y

Re: No data to be displayed

israrkhan — Mon, 30 Sep 2013 18:58:20 GMT

Hi Bikash,

on chart properties>> general tab>> calculation condition, use expression, for example :

let say for Chart X, you can write like, =count(distinct A)>=1,

mean when 1 or more values will be selected in list A then it will be calculated. and you can show a message to user to select 1 or more values from list A to see the data.

you can manage the others in same way...

Re: No data to be displayed

MayilVahanan — Mon, 30 Sep 2013 19:01:40 GMT

Try like this

GetSelectedCount(Revenuefacttable.BillToName) = 0 In calculation condition.

Its helps.

Re: No data to be displayed

Mon, 30 Sep 2013 19:01:49 GMT

Thanks for the response.

Really appreciate it.

Re: No data to be displayed

Mon, 30 Sep 2013 19:02:11 GMT

Great! It worked. Thanks and appreciate it.